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?