View Single Post
  #1   Report Post  
neilcarden neilcarden is offline
Junior Member
 
Posts: 26
Default Replacing #N/A with a '0' (zero)

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