Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Zipcode lookup?

  1. #1
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.
    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.

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  6. #6
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ~Anne Troy

  7. #7
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yey Tuggy! Your the man ;o)

  8. #8
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  9. #9
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    *bump*

  10. #10
    Board Regular
    Join Date
    Mar 2002
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •