Try this:

=IF(ISNA(VLOOKUP(........)),0,VLOOKUP(........))

Biff

"Nenagh" wrote in message
...
Hi, wondering if anyone can help.

I am using the vlookup function and i want 0 returned if an exact match
can
not be found?

Cheers
--
Nenagh