Hi! I am new to this forum! I'm always on it bc I have so many questions so I finally became a legit member
I work on quite a few reports and it would be amazing if I knew how to autofill/autogenerate counties by the column of zipcodes I have. I have seen similar questions posted about this topic, but it's been difficult for me to follow them.
I attached same work! Feel free to take a look! Thank you!!
Welcome to the forum!
Excel cannot magic the county out of thin air: you will need a reference table somewhere in the workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Yes! I figured I'd need to have a sheet listing all the zipcodes and counties in the USA to have a place to autofill from; once I have this do you know what equation I would need to have?
Well, it will depend entirely on how you decide to set up the lookup table. Give me the first few lines of data that you will use and then I'll be able to advise.
Still waiting. Two or three lines of sample lookup data will suffice.
Based on your posted file:
=VLOOKUP(D2,X2:Y50000,2,0)
Where D2=Zipcode
X2:Y50000 contains your "Lookup" table
X=Zipcode
Y=Corresponding County
OR
=INDEX(Y2:Y50000,MATCH(D2,X2:X50000,0))
If you have MS Access, here is a db that you can use to look up Zip Codes. You can input either the zip code to get the city and state and county or you can enter the city, state and county to get the zip code.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
One way. If you have all zip code list you can download USA zip code data base & using index match formula you can get result.
Plz refer search engine for zip code download.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
The zipped file causes Windows Explorer to crash here, Alan - repeatable.Originally Posted by alansidman
Ali--
Interesting, but I am unable to replicate the issue. I bring up the zipped file and open it without any problem.
Alan
Hello Alan,
Just wanted to say thanks for this city/state/zip/lat/long/county database. It is fabulous! Found this today while googling a solution and it is super helpful. Much appreciated....
Andy
Alan- thanks for sharing this database. it is super helpful!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks