Forum Discussion
Excel Functions
Find attached a matrix, and picture below I select Rare (0.5) in a cell and Modera (8) in another cell, i want function to return in a cell from matrix above. Like A (4) with green filled in. ...
In cell A13 try below formula:
=TOCOL(IF((A3:A7 = A11) * (A12 = C1:G1), C3:G7, NA()), 3)Hope this helps.
IlirU