Is there anyone know how I can compare the following data in Excel spread sheet

When comparing col A & Col C,

If A2 (tp-2) =C4 (tp-2) then put D4 (deleted) in B2


A B C D
1 TP-1 TP-3 new
2 TP-2 deleted TP-5 xx
3 TP-3 new TP-8
4 TP-4 TP-2 deleted
5 TP-5 xx TP-10


Please help & many thanks

Philip