Excel Function Help please!!!

[Kbillings]

I need to create a LOOKUP Excel function to find grades. I already used:

=LOOKUP(B5,{0,60,70,80,90,100},{"F","E","D","C","B","A"})

Which works fine. BUT It has to be done using a table array/vector as such

Bob 85 Grade??
Sara 92 Grade??

using the table:

A+ 95
A 90
B 80
C 70

I keep plugging formulas like: =VLOOKUP(B27,A20:B24,1,TRUE)
but it comes back NA or #VALUE??

I dont know what my problem is in using LOOKUP in a table??

Please Help!! Much Appreciated
Kristyn

 

[GlennUK]

Well, your columns are in the wrong order, and your data is in the wrong order. It should be something like:

0 F
60 E
70 D
80 C
90 B
95 A
100 A+

with a formula of =VLOOKUP(B27,A20:B24,2,TRUE)

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[GlennUK]

... note, the range A20:B24 is copied from your previous formula, and does not cover the number of values that you will have in your table. Adjust as necessary.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[Kbillings]

Thanks for the response! yeah, i figured out my problem was that the table was not in the correct order. Once i flipped the table, it worked fine.

Thanks!