D
DKinNorthCakalacki
I have been struggling with getting a formula to look at the input of one
cell, decide where it falls within a range, and then determine where to go
lookup the correct output.
Here is the formula I am using
=IF(I10<90%,LOOKUP(C8,C8),IF(I10>90.01%<105%,LOOKUP(E8,E8),IF(I10>105.01%<115%,LOOKUP(G8,G8),IF(I10>115%,LOOKUPI8,I8))))
This will give me either C8 or I8.
The other formula I used was:
=IF(I10<90%,LOOKUP(C8,C8),IF(I10>90.01%,LOOKUP(E8,E8),IF(I10>105.01%,LOOKUP(G8,G8),IF(I10>115%,LOOKUPI8,I8))))
This will give me C8 or E8.
So am I stuck to just this TRUE/FALSE or is there a way to have the
additional conditions met?
cell, decide where it falls within a range, and then determine where to go
lookup the correct output.
Here is the formula I am using
=IF(I10<90%,LOOKUP(C8,C8),IF(I10>90.01%<105%,LOOKUP(E8,E8),IF(I10>105.01%<115%,LOOKUP(G8,G8),IF(I10>115%,LOOKUPI8,I8))))
This will give me either C8 or I8.
The other formula I used was:
=IF(I10<90%,LOOKUP(C8,C8),IF(I10>90.01%,LOOKUP(E8,E8),IF(I10>105.01%,LOOKUP(G8,G8),IF(I10>115%,LOOKUPI8,I8))))
This will give me C8 or E8.
So am I stuck to just this TRUE/FALSE or is there a way to have the
additional conditions met?