Functions

[SMcPherson]

Hi Community,

I’m working on a project where I have a national list of zip codes but I essentially need to go from input zip codes to output county (not to be confused with country) or vice versa.

Does Excel have a function where I can output U.S. zip codes and counties?

[#2]

Hello @SMcPherson,

I would first suggest finding a database full of U.S. counties paired with their respective ZIP code. You can place this table in a worksheet of your excel workbook. Then, you can use INDEX() + MATCH() to find the ZIP code for county X or the county for ZIP code Y.

[#3]

https://support.microsoft.com/en-us/office/get-geographic-location-data-287b4cf2-3d7d-4bc1-b412-3d00...