Thread: How do I replace a return value of #N/A in a vlookup with zero?
View Single Post
  #5   Report Post  
Aladin Akyurek
 
Posts: n/a
Default How do I replace a return value of #N/A in a vlookup with zero?
1.

=SUM(Range,"<#N/A")

2. If you're sending the workbook across countries...

=SUMIF(Range,"<"&NA())

marketingman wrote:
Rather than #N/A being returned from a lookup for a value that is not in the
lookup table can I replace the returned #N/A with a zero?

Without being able to do this I am unable sum the returned values.
Reply With QuoteReply With Quote