Forum Discussion
Excel formulas
Hi there, I would like to populate a cell, based on the values that are chosen from the previous two cells, which are drop down lists. For example Column 1 - ''Ten'' is chosen, Column 2, ''Bl...
Alternatively, create a two-way lookup table. In the screenshot below, it is on the same sheet, but it can be on another sheet just as well.
The formula in C2 is
=INDEX($F$2:$I$11,MATCH(A2,$E$2:$E$11,0),MATCH(B2,$F$1:$I$1,0))
This can be filled down if required.