Auto fill county based on zip or city

**newtbee** · 08-12-2015, 04:00 PM

I have a spreadsheet of people including zip code, city, and county. Some counties are blank. How do I auto fill the county based on either the zip (first 4 digits of a zip +4 field) or the city? Sometimes we have city and no zip. For only blank fields, can I first check zip field, then use city to auto fill county? I have a master zip code and county reference file.

I understand vlookup can do this, but I'm not a programmer and don't know how to set this up, syntax etc.

Can anyone help?

**xladept** · 08-12-2015, 04:16 PM

Hi newtbee,

Welcome to the Forum!

A dictionary for Zips with def being County and a dictionary for counties with def being Zip-4 occurs to me

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**FDibbins** · 08-12-2015, 04:38 PM

Attached is a (relatively) new zip code/city/state listing. You coul use this in a VLOOKUP or INDEX/MATCH to pull in the data you need.

If you need help with this, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.