Recognize zip code for few cities ?

tasic89

New Member
Joined
Apr 12, 2021
Messages
24
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
I have one issue. Currently I am getting some data from other people, and their excel have address and city.

I need something that will recognize which city have some zip code, instead of me manually adding it via drop down lists (currently I have drop down list, and when I get city i need, i use drop down option to get zip code for that city).

E.g. Sacramento is 94203, Los Angeles is 90001 , Denver is 80201

It's that simple for me, I just have 1 zip code for 1 city. But I would like that somehow it recognize the zip code just "lookup" from one field. 90% i am sure that other people always type "Denver" or "Los Angeles", not something like mistype or use "LA" or "L.Angeles" ...
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
6,658
Office Version
  1. 365
Platform
  1. Windows
Here is a workbook macro enabled to allow you to look up Zip Codes and produce the city. It also allows you to name a city and get the zip codes for that city. You should download it from this secure site.

 
Solution

tasic89

New Member
Joined
Apr 12, 2021
Messages
24
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
Thx, works flawlessly for me, the first option is all i needed
 

Forum statistics

Threads
1,148,015
Messages
5,744,349
Members
423,863
Latest member
teehexcel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top