if a vlookup returns "#n/a" how can I make that zero?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
IF(ISNA(VLOOKUP(......)),0,VLOOKUP(....))

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

Dave
 
Is it possible to add or sum up two or more of these vlookup values? If yes,
can you tell me how?

Thanks!
 
If you want to add the results of 2 lookups, then use
=VLOOKUP(first_lookup_formula)+VLOOKUP(second_lookup_formula)

If you want to trap for NA() in each as shown below, then use
=IF(first_if_formula)+IF(second_if_formula)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Handling Dashes in IF statement 3
Help With VLOOKUP 2
Returning 0 instead of #N/A when no value is found 8
Vlook up value is #N/A 4
ISERROR on VLOOKUP 3
VLOOKUP and #N/A 2
Vlookups to return a N/A value 3
Vlookup, return zero if not found 4

Back
Top