Let's see if I understand you correctly...try this:
B1: =IF(ISNA(VLOOKUP(A1,$C$1:$D$5,2,0)),"",VLOOKUP(A1, $C$1:$D$5,2,0))

Copy that formula down to B5.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"philip" wrote:

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