| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup must return a value that is greater than
If a value is not found in a range, I would like it to return the smallest
value greater than itself. A B C i.e. 8 2 10 4 12 6 By default if I searched for 9, and needed the info from column C, I would 2 as my result, but instead I would like to get 4 as the result. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I return a blank for VLOOKUP instead of #N/A? | Excel Worksheet Functions | |||
| Excel 2000 VLOOKUP returns #N/A unless press F2 return on source? | Excel Worksheet Functions | |||
| vlookup - finding the next value that is GREATER than the lookup value? | Excel Worksheet Functions | |||
| Want VLookup to Return the row above | Excel Worksheet Functions | |||
| Vlookup of an if statement return | Excel Worksheet Functions | |||
Threaded Mode
