Help With Vlookup
 

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!


--
ashleyweese
------------------------------------------------------------------------
ashleyweese's Profile: http://www.excelforum.com/member.php...o&userid=27539
View this thread: http://www.excelforum.com/showthread...hreadid=470648

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


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=470648