Thread: How to convert VLOOPUP error value #NA to 0?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default How to convert VLOOPUP error value #NA to 0?
Embed your vlookup inside an if. Instead of =vlookup(...), use
=if(isna(vlookup(...)),0,vlookup(...))

"Rex" wrote:

Trying to sum a column that was built using VLOOKUP. Several of the values
returned in the column are #NA. The column will not sum. How can we write
the VLOOKUP formula to return error values = to 0 rather than #NA?
Reply With QuoteReply With Quote