Forum Discussion
Using a matrix to populate a cell
Hi all
I am trying to calculate the text value of a cell based on the text in two other cells. Basically I want to use a matrix (see below) of two possibilities to caluculate the third cell. Is this possible?:
| Insignificant | Minor | Moderate | Major | Catastrophic | |
| Almost Certain | Medium | High | High | Extreme | Extreme |
| Likely | Medium | Medium | High | High | Extreme |
| Possible | Low | Medium | Medium | High | Extreme |
| Unlikely | Low | Medium | Medium | High | High * |
| Rare | Low | Low | Medium | Medium | High * |
Thanks for any help :)
Hi Karen,
Index, Match, Match definitely appears to be the way to go with this one. Here's an example. I hope it helps.
Hi Karen
That should be something like:
=INDEX(data_array,MATCH(row_criteria;row_labels,0),MATCH(column_criteria,column_labels,0))
Hi Karen,
Index, Match, Match definitely appears to be the way to go with this one. Here's an example. I hope it helps.
thank you so much - this has been driving me mad!
Karen
