How to get an exact mactch with Vlookup
 

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

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

--
Andy.


"Grd" wrote in message
...
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

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.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Grd" wrote in message
...
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