| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I create a trend formula with range that changes | Excel Discussion (Misc queries) | |||
| Range Lookup in VLookup ?'s | Excel Worksheet Functions | |||
| How do I create an equivalent VLOOKUP function using FIND? | Excel Worksheet Functions | |||
| Trying to create formula to give range of stan.deviations of mean | Excel Discussion (Misc queries) | |||
| Dynamic Range for Function (Vlookup etc) | Excel Worksheet Functions | |||
Threaded Mode
