B1 is for values 80-90, B2 is for values 90.01 - 100, B3
is for values 100.01 - 110, etc.

B1, B2, B3 etc doesn't match what you have in your formulas. What does C8,
E8, G8 and I8 have to do with it?

You have replies to your post from last night. Did they not work?

--
Biff
Microsoft Excel MVP


"DKinNorthCakalacki" wrote in
message ...
I have ben trying to write a formula that will deliver a response based on
where the inout fits within a range.

In short, say Cell A1 = 95. Based on that value, Cell A@ would house a
formula that would then LOOKUP the value of a specified cell base upon its
A1's placement within a range - B1 is for values 80-90, B2 is for values
90.01 - 100, B3 is for values 100.01 - 110, etc.

The formula i tried was

=IF(I10<90%,LOOKUP(C8,C8),IF(I1090.01%,LOOKUP(E8, E8),IF(I10105.01%,LOOKUP(G8,G8),IF(I10115%,LOOKU P(I8,I8))))

but this only delivered C8 or E8. It will nor lookup G8 or I8

I also tried

=IF(I10<90%,LOOKUP(C8,C8),IF(I1090.01%<105.01%,LO OKUP(E8,E8),IF(I10105.01%<115%,LOOKUP(G8,G8),IF(I 10115%,LOOKUP(I8,I8)))))

But this ill only give me C8 or I8.

How can I write this formula so that it will work?