=IF(ISNA(vlookup_formula),"",vlookup_formula)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"dave" wrote in message
...
When I try to look with vlookup for a value that is not in the table
indicated, I get the message #N/A which indicates that the value cannot be
found (this is normal).

I would like to change this message #N/A into a value 0 or a blanc ""
because you cannot calculate with this value.

Is this possible??