vlookup, but ignore errors if #n/a

[Guest]

I have 2 worksheets and I am using the vlookup to pull data from worksheet 2
for worksheet 1. Then, on worksheet 1, I am using the sum function to add the
numbers together.

However, there are several cells on worksheet 1 that have #n/a because there
is no information on worksheet 2 to pull from. This causes an issue with the
sum function. Is there a way to have these cells change from #n/a to zero or
null?

 

[Guest]

Yep -

=IF(ISERROR(VLOOKUP(...)),0,VLOOKUP(...))

 

[chisigs2]

try something like this.... I use this one not sure it will work in a
vlookup though

=IF(N(F13),H13-H12,0)