Forum Discussion
SMcPherson
Oct 06, 2020Copper Contributor
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. ...
PReagan
Oct 06, 2020Bronze Contributor
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.