Thread: would like to substitute and return value of 0 for vlookup #N/A er
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default would like to substitute and return value of 0 for vlookup #N/A er
=IF(ISNA(VLOOKUP(......)),0,VLOOKUP(.......))

"egols" wrote:

I would like to return the value of 0 when the vlookup would otherwise return
the error #N/A - any suggestions?
Reply With QuoteReply With Quote