| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP to find a value that falls between a range?
Hi, How do you format a VLOOKUP to lookup something like a student's grade.
Next to each score I want a use VLOOKUP to return "A", "B", "C" etc. Scores -------- 92 73 87 89 etc. Lookup Table --------------- 100 90 A 89 80 B 79 70 C 69 60 D 59 50 F |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - find where a number falls in a start and end range | New Users to Excel | |||
| Checking if a certain day falls in a range | Excel Discussion (Misc queries) | |||
| Return a specified date when it falls within a range.... | Excel Discussion (Misc queries) | |||
| How to find if a date falls between 2 dates | Excel Worksheet Functions | |||
| Data falls in a range +/-1 | Excel Worksheet Functions | |||
Threaded Mode
