Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
is there any way to have excel return the next largest value that is MORE
than the 'lookup_value' when 'range_lookup' = 'true'? (it normally defaults to the next largest value that is LESS) or is there another way around this problem? eg - my lookup_value is 105; my table array may or may noy have 105, but always has numbers higher than 105 - the desired value to return is for the next number availble after 105. regards. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
INFORMATION ON FUNCTIONS IN EXCEL (EX. "IF", VALUE LOOKUP) | Excel Worksheet Functions | |||
Allow refence in the "table_array" position of Lookup functions | Excel Worksheet Functions | |||
Lookup Functions | Excel Worksheet Functions | |||
lookup using only the functions | Excel Worksheet Functions | |||
Excel Lookup Functions | Excel Worksheet Functions |