Thread: if a vlookup returns "#n/a" how can I make that zero?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default if a vlookup returns "#n/a" how can I make that zero?
=if(ISNA(VLOOKUP(.....)),0,VLOOKUP(......))

HTH

"sylvesma" wrote:

if a vlookup returns "#n/a" how can I make that cell show a zero instead of
an "n/a" but return a value when it is not n/a?
Reply With QuoteReply With Quote