Zipcode lookup?

Von Pookie · Mar 22nd, 2002, 03:13 PM

Ok. This one isn't mine, I was just asked to find out if it's even possible (personally, I don't think it will be, but I guess we do anything for our loved ones, don't we?

)

My husband has a spreadsheet that has address info of about 7,100(+/-) companies.
Unfortunately, none of these have the zip codes.

He would like to know if there is some way to set up a macro or something to look at the cells with the city and state, determine the correct zip code and have that automatically entered into a blank cell.

Would any of you out there have any ideas other than having to go through the USPS zipcode lookup on their site?

Thanks a bunch, guys!

Al Chara · Mar 22nd, 2002, 03:35 PM

There are zip code databases that you can download off the internet (most are not free). Then a very easy look up macro can be written.

Mark W. · Mar 22nd, 2002, 03:41 PM

Quote:

On 2002-03-22 14:13, Von Pookie wrote:
He would like to know if there is some way to set up a macro or something to look at the cells with the city and state, determine the correct zip code and have that automatically entered into a blank

Most large cities have more than 1 Zipcode. And then there's different Zip+Plus codes that can correspond to a floor in a high rise building.

ken · Mar 23rd, 2002, 11:30 AM

Hi Al,
I work on a similar kind of application . Could you tell me where these zip code databases are available on the net. any sites you can let me know about?
regards,
ken.

Quote:

On 2002-03-22 14:35, Al Chara wrote:
There are zip code databases that you can download off the internet (most are not free). Then a very easy look up macro can be written.

ken · Mar 24th, 2002, 09:28 PM

HI al, can you give me the web address of the sites that offer these zip codes?
Regards,
Ken

Anne Troy · Mar 25th, 2002, 12:10 AM

http://www.pc-shareware.com/zipcode.htm
http://www.speedkeys.com/download.htm (1996)

Dave Hawley · Mar 25th, 2002, 01:20 AM

Yey Tuggy! Your the man ;o)

Von Pookie · Mar 25th, 2002, 08:05 AM

I downloaded and installed SpeedKey just to try it out.

Can anyone help me with how to get Excel to look it up?

Sorry to be such a pest, but that's what the board is for, isn't it?

Thanks,

Von Pookie · Mar 26th, 2002, 08:51 AM

*bump*

wi_guy · Mar 26th, 2002, 01:24 PM

Well, the good news.....I'm REALLY bored at work, so I downloaded, sppedkey, extracted the ZIP data and saved it as a spreadsheet. The bad news....how to get that to you?

Also, you have to keep in mind that for many Cities, it will have several different zipcodes, so you will be looking up a zip for that city, but not necesarily the correct one.

Mar 22nd, 2002, 03:13 PM	#1
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	Ok. This one isn't mine, I was just asked to find out if it's even possible (personally, I don't think it will be, but I guess we do anything for our loved ones, don't we? ) My husband has a spreadsheet that has address info of about 7,100(+/-) companies. Unfortunately, none of these have the zip codes. He would like to know if there is some way to set up a macro or something to look at the cells with the city and state, determine the correct zip code and have that automatically entered into a blank cell. Would any of you out there have any ideas other than having to go through the USPS zipcode lookup on their site? Thanks a bunch, guys! __________________ Kristy How to post (Video) Show your sheet on the board (HTML Maker FAQ)

Mar 22nd, 2002, 03:35 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	There are zip code databases that you can download off the internet (most are not free). Then a very easy look up macro can be written. __________________ Kind regards, Al Chara

Mar 25th, 2002, 12:10 AM	#6
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	http://www.pc-shareware.com/zipcode.htm http://www.speedkeys.com/download.htm (1996) __________________ ~Anne Troy

Mar 25th, 2002, 08:05 AM	#8
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	I downloaded and installed SpeedKey just to try it out. Can anyone help me with how to get Excel to look it up? Sorry to be such a pest, but that's what the board is for, isn't it? Thanks, __________________ Kristy How to post (Video) Show your sheet on the board (HTML Maker FAQ)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 24th, 2002, 09:28 PM	#5
ken New Member Join Date: Mar 2002 Posts: 2	HI al, can you give me the web address of the sites that offer these zip codes? Regards, Ken

Mar 25th, 2002, 01:20 AM	#7
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Yey Tuggy! Your the man ;o)

Mar 26th, 2002, 08:51 AM	#9
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	bump

Mar 26th, 2002, 01:24 PM	#10
wi_guy Board Regular Join Date: Mar 2002 Posts: 50	Well, the good news.....I'm REALLY bored at work, so I downloaded, sppedkey, extracted the ZIP data and saved it as a spreadsheet. The bad news....how to get that to you? Also, you have to keep in mind that for many Cities, it will have several different zipcodes, so you will be looking up a zip for that city, but not necesarily the correct one.