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?