How to get an exact mactch with Vlookup

G

Grd

Hi,

I'm using a Vlookup but get a result even if the value I'm looking up is not
the same as the one the table.

I want to get an error if I don't find and exact match. Am I doing something
wrong?

Thanks In advance
Gordon
 
G

Guest

Hi
Make sure you are including the last argument of the function as FALSE,
otherwise an approximate match will do!
 
J

JulieD

Hi Gordon

the VLOOKUP function has four parameters, the fourth, if omitted, will allow
the VLOOKUP function do an approximate match ... if you want an exact match
you need to put FALSE or 0 in the fourth parameter.
 
Top