=IF(ISNA(vlookup_formula),0,vlookup_formula)

--

HTH

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


"Cathrine" wrote in message
...
is there a way to return a zero or blank in the place of #n/a in a vlookup
result that is FALSE?