Hello all,

In sheet1 Col.A I have many Zip codes and In sheet2 Col.A,B,C,D I have many
Zip codes also and in Col.E I have Phone numbers. How can I match Sheet1 Col.
A cell A:1 with sheet2 Col.A,B,C,D and If matches I would like to Copy
corresponding Col.E cell to sheet1 Col.B and look for the next one below and
then to the end of the column then the next column and paste it to sheet1
corresponding row. Since I am interested in getting sheet2 Col.E matches I
will not neet to have duplicates, for example in the sample below I'll get
cell E:1 copied to sheet1 because A:1 matches and next time If B:1 had 94597
I wouldn't need to have E:2 because I already have it from Row.A.
I hope I explained right. And if I get dups. in result there will be no
problem I will delete them manually.

Thank you in advance.


Ex.

In Sheet1
Col.A
94597
94593
:
:

In Sheet2

Col.A Col.B Col.C Col.D Col.E

94597 94600 94591 96523 925 921
94598 94597 94597 97863 925 933
94599 94594 94597 35624 926 922
94597 94593 94565 94597 925 932


The result would be:

In sheet1

Col.A Col.B Col.C Col.D Col.E Col.F Col.G Col.H
94597 925 921 925 932 925 933 925 933 925 922 926 932
94593 925 932

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200708/1