Thread: if a vlookup returns "#n/a" how can I make that zero?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sylvesma sylvesma is offline
external usenet poster
  
Posts: 1
Default if a vlookup returns "#n/a" how can I make that zero?
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