autofill city and state when typing in zip code

**shughes6288** · 04-20-2012, 11:05 AM

I have one sheet that has a list of zip codes with the corresponding city and states set up with the zips in column a, cities in column b, and states in column c. I want to make a list of my customers but there are so many and instead of typing the cities and states I want them to autofill when I type in the zip code. I have no idea how to do this but I know there is a way to. I need a step by step direction on how to do this.

**Fotis1991** · 04-20-2012, 11:11 AM

Hi and welcome to the forum

I thing that you need VLOOKUP or INDEX & MATCH functions for this.

Would you like to upload a small sample of your workbook and we'll show you to do it?

**shughes6288** · 04-20-2012, 11:13 AM

O yes I totally would. I have two separate ones. I haven't started the addresses yet because I wanted to figure this formula out first.

**shughes6288** · 04-20-2012, 11:26 AM

Where do I upload it?

**Fotis1991** · 04-20-2012, 11:29 AM

To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

**shughes6288** · 04-20-2012, 11:32 AM

i attached the zip codes book

**Fotis1991** · 04-20-2012, 12:16 PM

Apologize for the delay, but my Internet conection, has problems..

So, we greate a Named List(Insert>>Names>>Define, for your zips, let;s say in F5, or enywhere you like(to any sheet)

Then in G5, put this.

=IF(F5="";"";INDEX(B2:B39;MATCH(F5;ZIP;0)))

In H5, this

=IF(F5="";"";INDEX(C2:C39;MATCH(F5;ZIP;0)))

Change the semi-colons to comma.

**jbjlc** · 01-07-2016, 12:35 PM

I want to do the something. Can you help me? on two different table I have to different county's with all there towns and
zip code and state. I want to be able to be able to just type in the zip code and auto fill the town, county, and country. is this possible ?