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(......))

HTH

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

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?

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

Thanks!

"Toppers" wrote:

=if(ISNA(VLOOKUP(.....)),0,VLOOKUP(......))

HTH

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

If you want to add the results of 2 lookups, then use
=VLOOKUP(first_lookup_formula)+VLOOKUP(second_look up_formula)

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

"Cynthia" wrote in message
...
Is it possible to add or sum up two or more of these vlookup values? If
yes,
can you tell me how?

Thanks!

"Toppers" wrote:

=if(ISNA(VLOOKUP(.....)),0,VLOOKUP(......))

HTH

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