Home |
Search |
Today's Posts |
#1
|
|||
|
|||
If I have the zip code can I make it put the city in another cell
I have over 800 address, all without the city but they all do have the zip
code. Is there a function where I can have it refer to the zip code cells in order to produce the city??? |
#2
|
|||
|
|||
Only if you have a table with zip codes and cities, if so you can use
VLOOKUP(Zipcode,LookupTable,2,0) Otherwise no, how would excel know of zip codes unless they are put in there first? Why not use US post and get it from there, they have a zip lookup Regards, Peo Sjoblom "Carrie" wrote: I have over 800 address, all without the city but they all do have the zip code. Is there a function where I can have it refer to the zip code cells in order to produce the city??? |
#3
|
|||
|
|||
So if I had the city data, then I could do it... but where do you get the
data? The US post office website will only give you one city at a time, do you know of a place I can get this kind of data from? "Peo Sjoblom" wrote: Only if you have a table with zip codes and cities, if so you can use VLOOKUP(Zipcode,LookupTable,2,0) Otherwise no, how would excel know of zip codes unless they are put in there first? Why not use US post and get it from there, they have a zip lookup Regards, Peo Sjoblom "Carrie" wrote: I have over 800 address, all without the city but they all do have the zip code. Is there a function where I can have it refer to the zip code cells in order to produce the city??? |
#4
|
|||
|
|||
Or if you are feeling even more adventurous...
http://www.usps.com/ncsc/addressinfo...ssinfomenu.htm SongBear "Carrie" wrote: So if I had the city data, then I could do it... but where do you get the data? The US post office website will only give you one city at a time, do you know of a place I can get this kind of data from? "Peo Sjoblom" wrote: Only if you have a table with zip codes and cities, if so you can use VLOOKUP(Zipcode,LookupTable,2,0) Otherwise no, how would excel know of zip codes unless they are put in there first? Why not use US post and get it from there, they have a zip lookup Regards, Peo Sjoblom "Carrie" wrote: I have over 800 address, all without the city but they all do have the zip code. Is there a function where I can have it refer to the zip code cells in order to produce the city??? |
#5
|
|||
|
|||
Carrie
in continuing with Peo's theme: try http://www.usps.com/webtools/ If you are up to doing some programing, you might be able to use this from the USPS. I have never used it, myself, but Excel's ability to connect to the internet and get info is pretty good. Hope this helps SongBear "Carrie" wrote: So if I had the city data, then I could do it... but where do you get the data? The US post office website will only give you one city at a time, do you know of a place I can get this kind of data from? "Peo Sjoblom" wrote: Only if you have a table with zip codes and cities, if so you can use VLOOKUP(Zipcode,LookupTable,2,0) Otherwise no, how would excel know of zip codes unless they are put in there first? Why not use US post and get it from there, they have a zip lookup Regards, Peo Sjoblom "Carrie" wrote: I have over 800 address, all without the city but they all do have the zip code. Is there a function where I can have it refer to the zip code cells in order to produce the city??? |
#6
|
|||
|
|||
Stupid Bear should get all of this at once...
Again, in the spirit of what Peo already suggested: Google zip codes and get some other resources, including some downloadable databases (for a fee or subscription, reason for subscription: zip codes change and are added to all the time) http://www.google.com/search?q=Zip+c...r=&newwindow=1 some typical hits: http://www.zip-codes.com/ www.zipwise.com www.teamredline.com/zc/ http://www.zipcodedownload.com/ http://www.zipcodeworld.com/ http://spatialnews.geocomm.com/newsl.../zipcodes.html SongBear "Carrie" wrote: So if I had the city data, then I could do it... but where do you get the data? The US post office website will only give you one city at a time, do you know of a place I can get this kind of data from? "Peo Sjoblom" wrote: Only if you have a table with zip codes and cities, if so you can use VLOOKUP(Zipcode,LookupTable,2,0) Otherwise no, how would excel know of zip codes unless they are put in there first? Why not use US post and get it from there, they have a zip lookup Regards, Peo Sjoblom "Carrie" wrote: I have over 800 address, all without the city but they all do have the zip code. Is there a function where I can have it refer to the zip code cells in order to produce the city??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make Excel display HTML code as text | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) |