How to Create VLookup for a range of specified grades?
Assume the numeric values are in A2:A60 and the grade letters in B2:B6,
create a table like this
0 F
50 D
60 C
75 B
90 A
assume you put the score in C2 then use either
=VLOOKUP(C2,A2:B6,2)
or
=LOOKUP(C2,A2:A6,B2:B6)
If you want to skip the table altogether
=VLOOKUP(C2,{0,"F";50,"D";60,"C";75,"B";90,"A"},2)
or
=LOOKUP(C2,{0;50;60;75;90},{"F";"D";"C";"B";"A"})
you might want to add something in case C2 is empty
=IF(C2="","",VLOOKUP(C2,A2:B6,2))
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
Portland, Oregon
"Karaoke2lady" wrote in message
...
cell A2 contains text: Grade. Cells A2:B6 contain 0 to 49= F, 50 to 59= D,
60
to 74= C, 75 to 89= B, 90 to 100=A.Each letter grade should be matched up
with the lowest score possible for that grade. Using the insert,function,
Vlookup table I can not get what to put in each of the 4 categories except
for False. Please Help! Thank you.
|