It returns #N/A because it cannot find the value that i asked it to find(A17 in this case).

How can the source sheet have an error? There are just data there.

I am trying to make it return 0 or an empty cell if it doesnt find the data.

Thanks for the try anyway