Adding IFERROR IF MATCH Formula to each row

[MICowboy13]

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.

Dim LR As Long: LR = Cells(rows.Count, 1).End(xlUp).Row
    Dim j As Integer
    For j = LR To 3 Step -1
    If Cells(j, 4) <> "" Then
    Cells(j, 13) = "=IFERROR(IF(MATCH(Cells(j, 4),PartMaster!$A:$A,0),""Yes"",),""No"")"
    End If
    Next j

Thanks in advance