Thread: Making N/A become a zero
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CarlosAntenna
 
Posts: n/a
Default Making N/A become a zero
=IF(ISNA("your vlookup here"),0,"your vlookup here")
or
=IF(ISERROR("your vlookup here"),0,"your vlookup here")

--
Carlos

"Jaye" wrote in message
...
If I do a VLOOKUP and the resulting answer is #N/A, how can I get the
result
to show as a zero (0) instead?


Reply With QuoteReply With Quote