Vlookup match greater than lookup value

[papio5949]

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!

 

[RobWN]

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.

 

[daddylonglegs]

Hello papi,

What formula are you using and what is the lookup value?

 

[papio5949]

I am not using "false" as I do not want an exact match. Thanks for your reply.

 

[papio5949]

Hi daddylonglegs,
I found a solution - I used Match along with Vlookup and it corrected it.
Thanks for you concern.