Forum Discussion
Nested if function
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))
I initially tried to get this done by trying to simplify my challenge and didn't really propose the problem as I should have.
I am trying to create a spreadsheet that will track various inputs and produce the desired outputs. The suggestion you proposed could work but a new table would have to be created for row of input data.
I am attaching a screen shot that will make the requirements clearer.
As I enter new data on each row I need a formula in column H to reflect the results shown above. How would you handle that task?
- Thanks, good idea.
