Matching zip codes to counties

**kyohnke** · 09-25-2015, 02:04 PM

Hi everyone!
I have a rolling data sheet that staff insert zip codes into. What I need is for the column next to the zip code to populate the county associate with that. I have a list of roughly 70 zip codes that could be entered into this column so just using the IF function doesn't work due to size. What are my other options?

Thanks,
Katie

**stnkynts** · 09-25-2015, 02:10 PM

Somewhere in your workbook there needs to be a table that lists all zip codes with their corresponding county, otherwise how else is the code supposed to know. You would then use one of the many "LOOKUP" functions to retrieve the county name.

**Kenneth Hobson** · 09-25-2015, 03:07 PM

As explained, =HLookUP() is what I would use. Keep in mind that one county may have more than one zip code.

You can also include one of the various zip code or city API methods if you get a key. e.g. https://www.fullcontact.com/developer/docs/location/