| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup between values
Hi All,
Hi All, Any body knows how to make a vlookup between to vlaues? i have this table ----------------------------------------------- | x | A | B | C | ----------------------------------------------- | 1 | Name | Min | Max | ----------------------------------------------- | 2 | Jason | 0 | 129 | ----------------------------------------------- | 3 | Brian | 130 | 226 | ----------------------------------------------- | 4 | George | 227 | 478 | ----------------------------------------------- | 5 | Michael | 479 | 548 | ----------------------------------------------- what i want is to make a vlookup to look for the value givin -which is between the Min and Max column ex. 112 - and return the name which should be "Jason in this case. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combine multiple values in a table into one cell using vlookup? | Excel Worksheet Functions | |||
| VLOOKUP using another table for comparison values | Excel Worksheet Functions | |||
| use vlookup or other to find the nearest values (<) or interpola | Excel Worksheet Functions | |||
| Vlookup on a worksheet with similar values | Excel Worksheet Functions | |||
| vlookup returning multiple values | Excel Worksheet Functions | |||
Threaded Mode
