+ Reply to Thread
Results 1 to 8 of 8

Need VBA to look up for ZIP code in address column.

  1. 01-06-2015, 10:29 AM #1
    winmaxservices1
    winmaxservices1 is offline
    Forum Contributor
    Join Date
    03-12-2014
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    118

    Need VBA to look up for ZIP code in address column.

    I have Address in one column "A" with zip code/Pin code number.
    and have another sheet with list of zip code and location
    Want to lookup for the pincode in address column and show the location in column next to address(Result Column "B")
    We will Keep adding Zip code and place time to time Maping sheet
    Also will keep adding address in Address sheet
    Required result marked in yellow. please refer atatchment
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 01-06-2015, 10:58 AM #2
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Need VBA to look up for ZIP code in address column.

    Try this......
    Please Login or Register  to view this content.
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  3. 01-06-2015, 01:37 PM #3
    winmaxservices1
    winmaxservices1 is offline
    Forum Contributor
    Join Date
    03-12-2014
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    118

    Re: Need VBA to look up for ZIP code in address column.

    Hey,

    No it is not working. Please check the attachment.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 01-06-2015, 01:40 PM #4
    winmaxservices1
    winmaxservices1 is offline
    Forum Contributor
    Join Date
    03-12-2014
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    118

    Re: Need VBA to look up for ZIP code in address column.

    It is not working may be because it is counting last six characters. But in my data it need count 6 digit number anywhere in string
    Reply With QuoteRegister To Reply
  5. 01-06-2015, 02:09 PM #5
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Need VBA to look up for ZIP code in address column.

    Yes you are correct. The samples you showed contained zip codes at the end of the addresses.
    Please find the attached sheet and click on the Orange Button on the Address Sheet to get the desired locations on column B.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 01-06-2015, 02:21 PM #6
    rcm
    rcm is offline
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Need VBA to look up for ZIP code in address column. 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 01-06-2015, 02:23 PM #7
    winmaxservices1
    winmaxservices1 is offline
    Forum Contributor
    Join Date
    03-12-2014
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    118

    Re: Need VBA to look up for ZIP code in address column.

    Excellent Bro. Thank you.
    Reply With QuoteRegister To Reply
  8. 01-06-2015, 02:29 PM #8
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Need VBA to look up for ZIP code in address column.

    You're welcome and thanks for the feedback.
    If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Converting a complete, single column address into separate columns for ADDRESS, CITY, ST,
    By jeffrogerssn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2012, 10:34 AM
  2. Ping Host Name Column A IP address Result column B Response time Column c
    By NickMac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-13-2012, 03:23 AM
  3. Email selected print section to address located in a cell instead of email address in code
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-08-2012, 01:57 PM
  4. Excel 2007 : How do I search an address text string within a column and return the zip code in the
    By marchsusan in forum Excel General
    Replies: 3
    Last Post: 07-27-2011, 02:29 PM
  5. changing cell address to row/column address
    By michaelbails in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-30-2010, 09:47 AM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1