Thread: How do I replace a return value of #N/A in a vlookup with zero?
View Single Post
  #3   Report Post  
mbarron
 
Posts: n/a
Default How do I replace a return value of #N/A in a vlookup with zero?
Try this:

If(isna(vlookup(your lookup)),0,vlookup(your lookup))

Reply With QuoteReply With Quote