LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mkbatch
 
Posts: n/a
Default range_lookup in lookup 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
INFORMATION ON FUNCTIONS IN EXCEL (EX. "IF", VALUE LOOKUP) skye1971 Excel Worksheet Functions 1 February 1st 06 07:27 PM
Allow refence in the "table_array" position of Lookup functions fcjssc Excel Worksheet Functions 1 March 3rd 05 01:38 PM
Lookup Functions Sharon Excel Worksheet Functions 6 February 20th 05 05:04 AM
lookup using only the functions seven t Excel Worksheet Functions 3 December 11th 04 04:55 AM
Excel Lookup Functions Paul Adams Excel Worksheet Functions 1 November 10th 04 02:40 PM


All times are GMT +1. The time now is 03:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"