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)
 
Top