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?