Functions

%3CLINGO-SUB%20id%3D%22lingo-sub-1747809%22%20slang%3D%22en-US%22%3EFunctions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1747809%22%20slang%3D%22en-US%22%3EHi%20Community%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%E2%80%99m%20working%20on%20a%20project%20where%20I%20have%20a%20national%20list%20of%20zip%20codes%20but%20I%20essentially%20need%20to%20go%20from%20input%20zip%20codes%20to%20output%20county%20(not%20to%20be%20confused%20with%20country)%20or%20vice%20versa.%3CBR%20%2F%3E%3CBR%20%2F%3EDoes%20Excel%20have%20a%20function%20where%20I%20can%20output%20U.S.%20zip%20codes%20and%20counties%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1747809%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1749056%22%20slang%3D%22en-US%22%3ERe%3A%20Functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1749056%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F821270%22%20target%3D%22_blank%22%3E%40SMcPherson%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20first%20suggest%20finding%20a%20database%20full%20of%20U.S.%20counties%20paired%20with%20their%20respective%20ZIP%20code.%20You%20can%20place%20this%20table%20in%20a%20worksheet%20of%20your%20excel%20workbook.%20Then%2C%20you%20can%20use%20INDEX()%20%2B%20MATCH()%20to%20find%20the%20ZIP%20code%20for%20county%20X%20or%20the%20county%20for%20ZIP%20code%20Y.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1750002%22%20slang%3D%22en-US%22%3ERe%3A%20Functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1750002%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fget-geographic-location-data-287b4cf2-3d7d-4bc1-b412-3d00f45dbbd6%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fget-geographic-location-data-287b4cf2-3d7d-4bc1-b412-3d00f45dbbd6%3C%2FA%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
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 Replies

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.