Thread: replacing a #na
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pammy Pammy is offline
external usenet poster
 
Posts: 96
Default replacing a #na

I have a vlookup and when there is nothing for it to lookup as of yet, I get
a #Na, is there an =if iserror fomula I can add to the vlookup that will let
me add a "0" instead of the #na?