Formula column number same as the row it reads from another column, through loop

[karthidurai]

I have a sheet automatically created, depend on some condition I need to read the values on the column A, check with another sheet whether it exists , and print "Yes" or "No" on column D. The formula in column D is "=IF(ISNA(MATCH(A4,proj_req!F:F,0)),""No"",""Yes"")"
How can I create a loop stmt so that column D has the above formula, i.e
Do While current_Row < lastRow
ThisWorkbook. Sheets("features").Range("D" & current_Row).formula = "=IF(ISNA(MATCH(A4,proj_req!F:F,0)),""No"",""Yes"")" current_Row = current_Row + 1
Loop
inside MATCH(A should have the same row as the D current_Row)

Could you do the needful?

 

[Fazza]

welcome. if I understand correctly, the loop is not needed. how is this,

ThisWorkbook.Sheets("features").Range("D" & current_Row & ":D" & lastRow).FormulaR1C1 = "=if(isna(match(rc1,proj_req!c6:c6,0)),""No"",""Yes"")"