No, they are the same thing. "0" is just quicker to type..

Regards,

Gav.

"Sulasno" wrote:

thanks
re read the help and realise my function lacks the 4th argument

Any difference is using "0" or "False"

tia


"Gav123" wrote in message
...
Hi,

Try this
=VLOOKUP($K$2,Sheet1!$A:$G,2,0)

The addition of (,0) on the end of your formula will only return a result
if
there is an exact match in your lookup table.

Hope this helps,

Gav.
"Sulasno" wrote:

Using Excel 2002;

using a formula; =VLOOKUP($K$2,Sheet1!$A:$G,2) on cell K3

irrespective of what value I input into K2, I get a result in cell K3
regardless of whether K2 is valid or not

is this a bug or am I missing something?