Vlookup

  • Thread starter Thread starter Doron Klein
  • Start date Start date
D

Doron Klein

I want to use the vlookup function, but instead of find the equal or
small value that close to the lookup_value. I want to find the equal
or big value that close to the lookup_value.

Thank you.

Doron
 
I think the last argument shuld be "true"---see help <vlookp>
 
Hi!

If you sort descending the lookup table you can use a
combo index/match with a match_type argument of -1. See
Excel help on the match function for a description.

Biff
 
You must log in or register to reply here.

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

Lookup Value 2
Dynamic col_index_num in VLOOKUP? 5
Vlookup function 3
Vlookup problem 1
VLOOKUP - 0 instead of # N/A 8
limitation to Match formula? 2
Lookup function when 'lookup_value' does not always exists 1
vlookup with numeric and alphanumeric identifiers in lookup_value 1

Back
Top