View Single Post
  #4   Report Post  
Vinaya
 
Posts: n/a
Default


IF(ISERROR(VLOOKUP(C1,$A$1:$B$4,2,0)),0,(VLOOKUP(C 1,$A$1:$B$4,2,0)))

neilcarden wrote:
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