I have a list of zip code prefixes (the first three digits of a US zip code). I have another table that groups zip code prefixes into regions where A1= 'AL-N' (this is the region) and A2= '350-359, 362'. A2 represents all zip codes prefixes between 350 and 359 and also include prefix 362. What I would like to do, is assign the region from the table to a column in my list of zip code prefixes. Does anyone know how I might be able to do this? Thanks.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Zip code matrix
- Thread starter jrg24
- Start date
GerryZ
Well-known Member
- Joined
- Jul 4, 2014
- Messages
- 1,224
- Office Version
- 365
- Platform
- Windows
Hello jrg24!
I like this trick but I don' t understand all of the Issue because your </SPAN>actually</SPAN></SPAN></SPAN> working</SPAN></SPAN></SPAN> is already difficult and without see the spreadsheet is absolutely more difficult
Would be better to see a spreadsheet sample instead to using 1000s of words.
May you post a small screenshot or post a worksheet with DROPBOX or GOOGLEDRIVE so everybody can understand better?
Thank you in advance!</SPAN>
I like this trick but I don' t understand all of the Issue because your </SPAN>actually</SPAN></SPAN></SPAN> working</SPAN></SPAN></SPAN> is already difficult and without see the spreadsheet is absolutely more difficult
Would be better to see a spreadsheet sample instead to using 1000s of words.
May you post a small screenshot or post a worksheet with DROPBOX or GOOGLEDRIVE so everybody can understand better?
Thank you in advance!</SPAN>
Upvote
0
Similar threads
- Question
- Question
