Help With Vlookup

[ashleyweese]

I Need Help With The Vlookup Wizard. I Am Trying To Create An End Result Using Two Different Worksheets. Basically, I Am Trying To Lookup A Grade Scale To Input The Letter Grade That A Student Has Recieved. Please Help!

[duane]

if your grade scale is

0 F
60 D
70 C
80 B
90 A

and is placed in say A1:B5

=vlookup(grade cell, $A$1:$B$5,2,true)

where grade cell is the cell with the numeric grade

gives you the letter grade for a numeric grade

72 will result in C, etc