Yep -
=IF(ISERROR(VLOOKUP(...)),0,VLOOKUP(...))
--
Regards,
db
"Jess" wrote:
> 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?
Bookmarks