lookup tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If VLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the
largest value that is less than or equal to lookup_value.

I want to find the next LARGEST value in a table that I have sorted. Is this
possible?
 
Richard said:
If VLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the
largest value that is less than or equal to lookup_value.

I want to find the next LARGEST value in a table that I have sorted. Is this
possible?
Click to expand...

Looks like...

=INDEX(ReturnRange,MATCH(LookupValue,MatchRange,1)+(LOOKUP(LookupValue,MatchRange)<>LookupValue))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic col_index_num in VLOOKUP? 5
lookup number greater than 2
lookup number greater than 1
range_lookup in lookup functions 2
Nested functions using array/range names 3
Match function 1
Vlookup in Excel 2
VLOOKUP - columnar sheet with multiple matches - need to return a 7

Back
Top