I have city/state. How do I get the county they're in for a map chart?

[SandsB]

I need to use Excel to map ticket counts by county. County name isn't in my data. I know how to map by state so I assume I can do it by county. But how can I match the city/state to a county? I'm hoping somebody here has come across this problem and found a solution.

 

[alansidman]

Download this file that was developed a few years back and see if that does what you need.

ZIP2.xlsx | Powered by Box

app.box.com

 

[Logit]

Here is a zipped Zip Code listing:

Zip Code Database