The Problem


VLOOKUP returns a #N/A error when the lookup value isn't found.



=VLOOKUP(A2, ProductMaster!A:B, 2, FALSE)






If the value in A2 doesn't exist in the product master, the cell shows #N/A.

That's annoying on its own — but the real problem is that any formula referencing that cell also breaks.



=SUM(B2:B10) -- if any cell in...