View Single Post
  #3   Report Post  
Niek Otten
 
Posts: n/a
Default

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"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