Find the data from another sheet, if the input value does not exist leave blank

Hello,

I have 2 different reports coming from two different sources. I have to combine the datas from these two different reports. But the handicap is, some input values may not exist in the other chart. So in the other chart I am having "#N/A" error. I must convert these "#N/A" to zero. Because when I am trying to get the sum of the values, If the column containing "#N/A", then my sum is also getting error.

Example is attached.

Thanks in advance.

You can try something like this.....

Please Login or Register  to view this content.

Does this help?

You're welcome.
You may also click on * (star) to Add Reputation if the solution provided helped you. This is another way to say thanks.