Forum Discussion

SMcPherson's avatar
SMcPherson
Copper Contributor
Oct 06, 2020

Functions

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?
Formulas and Functions

2 Replies

  • Deleted's avatar
    Deleted
    Oct 06, 2020
    https://support.microsoft.com/en-us/office/get-geographic-location-data-287b4cf2-3d7d-4bc1-b412-3d00f45dbbd6
  • PReagan's avatar
    PReagan
    Bronze Contributor
    Oct 06, 2020

    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.

Resources