| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup between values
=INDEX(A2:A5,MAX(1,MATCH(112,B2:B5,1)+1))
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message oups.com... 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. |
| Reply |
| 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 | |||
Linear Mode
