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...
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,
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
