R
ricklongbow
Hello all. My first post. I have two worksheets A and B. Both contai
columns of five digit zip code values. A is of names and addres
(street/city/state/zip different columns) with 3500 rows. B is a shee
with every zip, city, state and county in the US. B is sorted by zip.
For each contact in A I want to lookup the same zip in B an
copy(merge?) the appropriate (same row) county into A.
"A"
Barnaby Joyce 2 Joyce Plaza Stony Point NY 10980
Frank Polloni 614 C Way W Stockbridge MA 01266
John Wall 2 Strawtown Road West Nyack NY 10994
"B"
10980 STONY POINT NY ROCKLAND
00544 W STOCKBRIDGE MA BERKSHIRE
10994 WEST NYACK NY ROCKLAND
Do the sheets need to be sorted ascending by zip to do the lookup?
Thank yo
columns of five digit zip code values. A is of names and addres
(street/city/state/zip different columns) with 3500 rows. B is a shee
with every zip, city, state and county in the US. B is sorted by zip.
For each contact in A I want to lookup the same zip in B an
copy(merge?) the appropriate (same row) county into A.
"A"
Barnaby Joyce 2 Joyce Plaza Stony Point NY 10980
Frank Polloni 614 C Way W Stockbridge MA 01266
John Wall 2 Strawtown Road West Nyack NY 10994
"B"
10980 STONY POINT NY ROCKLAND
00544 W STOCKBRIDGE MA BERKSHIRE
10994 WEST NYACK NY ROCKLAND
Do the sheets need to be sorted ascending by zip to do the lookup?
Thank yo