View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karaoke2lady
 
Posts: n/a
Default How to Create VLookup for a range of specified grades?

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.