I am struggling with appending data to an existing database. I have a table with all of the zipcodes, City and State that needs to be referenced an then populated to the City collumn with the appropriate city name.
I need a Vlookup that will pull the value from sheet 2 and populate the city column with the correct info
Last edited by [email protected]; 12-28-2012 at 05:44 PM.
Does this need to be a formula?
Here's a simple macro that looks up the city name based on the postal code:
Please Login or Register to view this content.
dcilley, welcome to the forum.
Do you mean pull info per the attached?
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
put this in Database!F2 and drag-fill down:
the ZIP column on Database tab is in number format, whereas on Zipcode Info tab it is in text format; hence the use of TEXT function - to convert number to text (will be useful in case of a zip-code like 01803 stored in number format, in which case the leading zero will be dropped by Excel).Please Login or Register to view this content.
Last edited by icestationzbra; 12-28-2012 at 05:55 PM.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
@sullivan - nice work.
Perfect, Thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks