How do I add vlookup functions together

M

Mike

I am trying to add vlookup figures together and some return #N/A, which leads
to no values being returned at all. Is there anyway around this
 
B

Bob Phillips

Do you mean

=VLOOKUP(A1&B1,M1:p20,3,False)

perhaps?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
P

paul

you need to "trap" the error
if(isna(vlookup_formula),"",vlookup_formula).You could also have iserror.You
can also have 0 instead of ""(blank).Your values should now add up
 
M

Max

Assuming the vlookups are within C1:C10, an option to add up the vlookups
"as-is", ie without error-trapping for #N/As is to try something like this

In say, C11: =SUMIF(C1:C10,"<>#N/A")
 
Top