-2

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, 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!

Improve this question
3
  • Sample spreadsheet: docs.google.com/spreadsheets/d/…
    – helloandyhihi
    May 5, 2023 at 2:11
  • 2
    Hi and welcome to Superuser. Please edit your question instead of adding information in comments. Also, please include a sample data and expected results either as screen caps (upload to imgur.com and line to them) or tables (how to format tables, otherwise the question becomes incomprehensible (and thus useless) once the link to the google sheet goes dead
    – cybernetic.nomad
    May 5, 2023 at 12:29
  • There are guides for filtering one list by another list. What research have you done and what have you tried?
    – music2myear
    May 6, 2023 at 1:21

1 Answer 1

Reset to default
0

Basic Syntax

=FILTER(range,COUNTIF(lookupValues,zipCodeColumn))

Sample Formula

=FILTER(A:D,COUNTIF(G2:G5,D:D))

More Excel Reading

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .