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

S

sylvesma

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?
 
D

Dave F

IF(ISNA(VLOOKUP(......)),0,VLOOKUP(....))

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

Dave
 
C

Cynthia

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

Thanks!
 
D

David Biddulph

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

Help With VLOOKUP 2
Multiple VLOOKUP in an IF statement 2
Same forumula returns both 0 & N/A 2
XIRR vs. IRR Function 11
Use & with two formulas 2
Handling Dashes in IF statement 4
wdActiveEndSectionNumber 1
Multiple IF Statement 2

Top