Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |