Try this:

=IF(COUNT(I10),IF(I10<=90%,C8,IF(I10<=105%,E8,IF(I 10<=115%,G8,I8))),"")

--
Biff
Microsoft Excel MVP


"DKinNorthCakalacki" wrote in
message ...
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(I1090.01%<105%,LOOKU P(E8,E8),IF(I10105.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(I1090.01%,LOOKUP(E8, E8),IF(I10105.01%,LOOKUP(G8,G8),IF(I10115%,LOOKU PI8,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?