| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need to select closest match using vlookup if it higher or lower
VLOOKUP() will not do what you want. You can use MATCH() and INDEX(), if the
list is sorted in descending order and you use -1 as the 3rd argument in the MATCH() function "vlookup help pls" wrote: i cant get vlookup to select the closest value if the closest value is higher it automatically selects the highest value below the cell value |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup? to match column in two sheets | Excel Discussion (Misc queries) | |||
| vlookup worksheet match in macro | Excel Worksheet Functions | |||
| Match Closest Results from Data Array | Excel Discussion (Misc queries) | |||
| Conversion | Excel Worksheet Functions | |||
| Closest number match help ... | Excel Worksheet Functions | |||
Hybrid Mode
