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
--
paul

remove nospam for email addy!



"Mike" wrote:

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