Hi Mick,

One way

=IF(ISNA(lookup_formula),"",lookup_formula)

this traps #N/A errors specifically, a more generic solution is

=IF(ISERROR(lookup_formula),"",lookup_formula)

--

HTH

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


"mick.smith1964" wrote in message
...
Hi

I have alot of Vlookup functions in a worksheet. Some return values,
others
do not which results in #N/A in the cell.

Is there a way to avoid #N/A being returned. All I want is either a
positive
value or an empty cell.

Thanks for any suggestions