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?