I am trying to find a simple way to do this:
I have a list of zip codes with an associated group number I have a second list of customer addresses.
I want to be able to add the code from the first list to the list of customer addresses.
My problem is that I have over 600 zip codes and over 1200 customers.
I was hoping a formula could do this, I have no experience with macros.
Example:
zip code group name address city state zip group
10001 6 john 1 main any st 10002
10002 7 joe s 2 main any st 10001
10003 8 julie s 3 main any st 10003
Thanks for any and all help!
Mary
Bookmarks