| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup - find an alternative approximate match
With vlookup, and a range lookup value of TRUE, when there is no exact match,
is it possible to return the smallest value that is greater than the lookup value (rather than next largest value that is less than lookup value)? Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Approximate match on string of text | Excel Worksheet Functions | |||
| How do I match using partial or approximate values? | Excel Worksheet Functions | |||
| Vlookup Approximate Match Question | Excel Worksheet Functions | |||
| Approximate matches with vlookup? | Excel Worksheet Functions | |||
| Vlookup approximate match question. | Excel Worksheet Functions | |||
Threaded Mode
