+ Reply to Thread
Results 1 to 3 of 3

How do I filter addresses based on a list of zip codes?

  1. #1
    Registered User
    Join Date
    05-04-2023
    Location
    Tabacky, Sticky
    MS-Off Ver
    1000
    Posts
    1

    Angry How do I filter addresses based on a list of zip codes?

    I'm planning to mail some postcards to potential business contacts.

    I've got a spreadsheet of 2,500+ addresses with columns including Name, Street Address, City, State, and zip code, etc. that cover the entire state of Colorado. But I only want to send the postcards to people near me and I have a list of around 150 zip codes that I'd like to narrow the list to.

    I've tried a number of things and haven't been able to get it to work. Ideally, I could output the filtered list of names and addresses to a new spreadsheet tab.

    The name, address and other info are in columns B through W. The list of target zip codes is in column AM.

    Any advice on how to get this done? I'm not technical and very frustrated. I can't get the Advanced Filter to do the job. The X & VLOOKUP functions have eluded me.

    If you could include an exact formula that only needs a little tweaking, that would be ideal. :-) Thank you!
    sample mailing list and zips.xlsx

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2411
    Posts
    26,726

    Re: How do I filter addresses based on a list of zip codes?

    Welcome to the Forum youreally !

    There is no Office version 1000 that I have ever heard of. Please update your profile. Meantime I am giving you an MS 365 solution.

    =FILTER(Business_Entities_in_Colorado!$B$2:$V$20,ISNUMBER(MATCH(Business_Entities_in_Colorado!$H$2:$H$20,Business_Entities_in_Colorado!$AL$2:$AL$175,0)))
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,309

    Re: How do I filter addresses based on a list of zip codes?

    Administrative Note:

    Welcome to the forum.

    Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

    With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

    Thank you for helping us to help you.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 12
    Last Post: 06-13-2022, 08:39 PM
  2. Replies: 1
    Last Post: 06-10-2022, 12:44 PM
  3. Finding Google Plus Codes for a database with addresses without VBA
    By rgoins82 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-24-2022, 10:19 AM
  4. How do I filter my data list from another list of zip codes.
    By rafayhaq in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-09-2019, 07:02 PM
  5. Filter contact list by zip codes from a list
    By rafayhaq in forum Access Tables & Databases
    Replies: 1
    Last Post: 07-17-2019, 02:25 AM
  6. [SOLVED] Addresses - truncate 11 digit zip codes and leave 5 digit zip codes
    By landisf in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-25-2013, 11:15 PM
  7. Filter Zip Codes from a list codes
    By jaugent27 in forum Excel General
    Replies: 3
    Last Post: 06-11-2013, 02:01 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1