"Lookup" value in range

[itfmm]

Hello,

I'm trying to use and array lookup formula to help identify where a value falls in a range of numbers. Here is the table with the ranges and corresponding identifiers:

0-60 A
60.01-70 B
70.01-75 C
75.01-80 D
80.01-85 E
85.01-90 F
90.01-95 G
95.01-97 H

So let's say the value I am looking at is in cell N16. If the value falls between 0 and 60.00 =A; if it falls between 60.01 and 70.00 =B; etc, etc.

When I use the formula below, say N16=62, the formula returns "N16=A."

=LOOKUP(N16,{0,0;60,"A";70,"B";75,"C";80,"D";85,"E";90,"F";95,"G";97,"H"})

Would anyone help me figure out what it is that I am missing?

Thanks so much!


Anna

 

[Simon4s]

=lookup(n16,{0,60,70,75,80,85,90,95},{"A","B","C","D","E","F","G","H"})

 

[itfmm]

You, sir, are brilliant and a hero in your own right! Can't thank you enough.