Quote:
Originally Posted by ricklongbow
Hello all. My first post. I have two worksheets A and B. Both contain columns of five digit zip code values. A is of names and address (street/city/state/zip different columns) with 3500 rows. B is a sheet 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 and 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 you
|
Have you tried using a combination of concatenate, left and right?