FORMULA: Auto-populate City Based on Zip (Kentucky Only)

[jeffcoleky]

I know this has been asked before, but threads like this one don't answer my question because I ONLY WANT ZIP CODES IN KENTUCKY.

I wish to be able to type in a ZIP CODE into column "B", and have it automatically fill-in the City in column "A". Since the state is always Kentucky, that whole column is already filled-in.

I could use the zip_codes list for the nation to copy Kentucky's zip codes only, then paste it into a column of a different sheet in this workbook to be able to parse the data from.

What formula could I use to automatically populate the data based upon this column of information? Even if you'd rather tell me the formula TYPE to search for, I might be able to figure it out--it seems like a simple concept.

 

[chuckles1066]

I'd use VLOOKUP ?

 

[jeffcoleky]

I'd use VLOOKUP ?

I tried this and it seems to work: =TEXT(VLOOKUP($Q$405,ZIPTABLE,COLUMN(B2),0),"00000")

Does that look correct?