Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 18th 05, 06:49 PM
Carrie
 
Posts: n/a
Default 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   Report Post  
Old May 18th 05, 07:01 PM
Peo Sjoblom
 
Posts: n/a
Default

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   Report Post  
Old May 18th 05, 07:22 PM
Carrie
 
Posts: n/a
Default

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   Report Post  
Old May 18th 05, 08:11 PM
SongBear
 
Posts: n/a
Default

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   Report Post  
Old May 18th 05, 08:26 PM
SongBear
 
Posts: n/a
Default

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   Report Post  
Old May 18th 05, 08:26 PM
SongBear
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I make Excel display HTML code as text roopytoopdongle Excel Discussion (Misc queries) 1 March 20th 05 06:40 AM
Error trapped only while stepping through the code - Not triggered when run Jeff Excel Discussion (Misc queries) 7 March 7th 05 06:29 PM
Opening a file with code without a set file name jenkinspat Excel Discussion (Misc queries) 1 March 4th 05 10:50 AM
Opening a file with code without a set file name jenkinspat Excel Discussion (Misc queries) 1 March 3rd 05 03:40 PM
Error trapped only while stepping through the code - Not triggered when run Jeff Excel Discussion (Misc queries) 0 February 28th 05 06:26 PM


All times are GMT +1. The time now is 06:25 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017