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

IF vlookup returns #N/A, THEN 0, ELSE do the vlookup and return its value.

Dave
--
Brevity is the soul of wit.


"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