Not that simple :-)

The value in in Column A2 has to be searched for a match in Column G
Once a match was found, e.g, A2 matched with G50, then the value in
D50 would be copied to J50

This process would repeat it self

A3 would be searched and matched to a value in Column G and so on.




Not that simple :-)

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

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