Lookup "greater than or equal to" in lookup array

G

Guest

This is my first post to the discussion group, so hi all.

I'd like to be able to use a vlookup to return a value where the first
column of the lookup array is "greater than or equal" to the value of the
lookup cell. Using TRUE, of course, returns a "less than or equal to" value.
Does anyone know if there is something similar for "grater than"?

Thanks

Phil
 
N

Niek Otten

Sort the table descending and use

=MATCH((LookupValue,LookupArray,-1)

This gives you the relative position in the table; use INDEX() to retrieve
the item you need
 
G

Guest

Thanks, it works a treat!!


Niek Otten said:
Sort the table descending and use

=MATCH((LookupValue,LookupArray,-1)

This gives you the relative position in the table; use INDEX() to retrieve
the item you need
 

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

Top