Need macros solution, thanks in advance.

Closed
Report
Posts
1
Registration date
Friday July 3, 2015
Status
Member
Last seen
July 3, 2015
-
A B C D

887806009723 B00A3ZFW7I 887806009723
887806009730 B00A3ZFWUU 887806009730
887806009747 B00A3ZFYGC 887806009747
887806009754 B00A3ZFZ7A 887806009754
887806009761 B00A3ZFZZ2 887806009761
887806010071 B00IA67J50 887806010149
887806010071 B00CD57VMA 887806010156
887806010088 B00IA67NIS 887806010163
887806010088 B00CD57Z08 887806010170
887806010095 B00IA67RNO 887806010187
887806010095 B00CD582EQ 887806010194
887806010101 B00IA67T32 887806010200
887806010101 B00CD5862O 887806010217
887806010118 B00DLMEKY6 887806010224
887806010125 B00DLMERD0 887806010231

In above table need a macros are a if logic for below scenario,

If A and C value matches then copy the B value to D else leave it empty field.

Thanks in advance,
Rakesh