=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??
|