So you did not understand or just misread and maybe you do not know even under VBA
some Excel features can be more efficient, faster and easier to maintain than some bad classic looping code !
So according to your attachment a VBA demonstration as a beginner starter :
Const F = "IF((A2:A#=""Yes"")*(B2:B#=C2:C#),""Processed"","""")"
.Range("D2:D" & .Count).Value2 = .Parent.Evaluate(Replace(F, "#", .Count))
Do you like it ? So thanks to click on bottom right Like !