Forum Discussion
Nested if function
I have 3 inputs that may be entered in A3 (Fruit, meat, or veg) and 2 inputs (buy or sell) that may be entered in cell B3. I generated a reference table of pricing for the 6 different combinations of...
I'd use a two-dimensional lookup table:
The formula in C3 is
=INDEX($F$2:$G$4,MATCH(A3,$E$2:$E$4,0),MATCH(B3,$F$1:$G$1,0))
I'd use a two-dimensional lookup table:
The formula in C3 is
=INDEX($F$2:$G$4,MATCH(A3,$E$2:$E$4,0),MATCH(B3,$F$1:$G$1,0))
Thanks, good idea.