=IF(ISNA(lookup_formula),0,lookup_formula)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"neilcarden" wrote in message
...
Hi all,
I'm using a Vlookup to pull figures over from another sheet. Is there a
way that when there isn't any data to pull across, instead of displaying
#N/A it could display a zero?
Thanks in advance...
Neil
--
neilcarden
|