Hi
in J2 enter
=IF($A$2=G2,D2,"")
and copy down

--
Regards
Frank Kabel
Frankfurt, Germany

"Avram Berman" schrieb im Newsbeitrag
...
If A2 is found in Column G then insert the value of D2 into J2

e.g.,

If A2 is found at G50, then insert the value of D50 into J50

where
A = Address1 and G = Address 1 and D = Zip and J = Zip copied from D

Thank you.