Adding IFERROR IF MATCH Formula to each row

Hi,

I am currently trying to add a formula to column M to match the data in column D to another sheet called PartMaster. If the data exist it should return "Yes" and if not "No". I'm not sure how to say that I want it to use the current row to match. I have tried to use the following, Cells(j, 4) is the part I have incorrect.

Please Login or Register  to view this content.

Thanks in advance

Untested?

Please Login or Register  to view this content.

Thanks again John!

Always welcome. Glad to help out.