Vlookup match greater than lookup value

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

Guest

Help! My vlookup formula produces a match that is greater than the lookup
value. The values in the first column of the table is in ascending order and
none of them are text. It's driving me crazy!
 
Did you miss the "FALSE" parameter in the statement?
i.e. VLOOKUP(key,range,col,FALSE)
The parameter will force the function to find an exact match.

If all else fails - try help.
 
Hi daddylonglegs,
I found a solution - I used Match along with Vlookup and it corrected it.
Thanks for you concern.
 

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

vlookup - find an alternative approximate match 4
vlookup and match first value greater than 4
DateRange Lookup no exact match, can't use lesser 4
Finding value using greater than, Vlookup, and nested If 2
sun results of a vlookup across a range 3
Vlookup array formula problem 2
Match function 1
First row where a cell is zero 1

Back
Top