| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting the next higer value with Vlookup - True
In VLookup / Hlookup function the True parameter gives the closest
match with the search value but less than the search value.... i want to get the next greatest values of the Search Value.... how to do it.... Example ..... A B C 5 10 15 6 11 16 9 14 19 If i use =Vlookup(7,[Array],2,0)/ =Vlookup(7,Array],2,True) .... the answer is get is 11 BUT how to get it as 14!!!??? Please reply me at : |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup to bring in not true data. | Excel Discussion (Misc queries) | |||
| VLOOKUP Range_lookup TRUE | New Users to Excel | |||
| vlookup with result TRUE not updating cell | Excel Worksheet Functions | |||
| Vlookup to return the next true value | Excel Discussion (Misc queries) | |||
| vlookup, true false issue | Excel Programming | |||
Threaded Mode
