Replacing #N/A with a '0' (zero)

N

neilcarden

Hi all,

I'm using a Vlookup to pull figures over from another sheet. Is there
way that when there isn't any data to pull across, instead of displayin
#N/A it could display a zero?

Thanks in advance...

Nei
 
B

Bob Phillips

=IF(ISNA(lookup_formula),0,lookup_formula)

--

HTH

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

Niek Otten

=IF(ISNA(YourFormula),0,YourFormula)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Top