Which formula should I use?

I’m working with about 4,000 names and zip codes of local volunteers on our registry. I need to sort them into specific jurisdictions based on their zip code. I have a list of my state zip codes matched with the jurisdiction they belong to.

What I need to do is find the formula that will: 1) scan the 4,000 numbers, from A1-A4000 and 2) find a specific zip code 3) **everywhere it finds that zip code e.g., “12345” I need it to put an e.g., “10” in the B column

I’ve tried using CANCATENATE, IF, VLOOKUP, INDEX+MATCH and several other formulas (I got a little desperate), but for the life of me I can’t get it to do it for the whole document — the “everywhere you find this in row A, put this in row B”

Thanks so much for your help! 


By: Mary

5 thoughts on “Which formula should I use?

  1. Karol

    Howdy! I understand this is kind of off-topic however I had to ask.

    Does running a well-established website like yours require a large
    amount of work? I am brand new to blogging however I do write in my journal
    on a daily basis. I’d like to start a blog so I can share my personal experience and feelings online.
    Please let me know if you have any recommendations or tips for
    new aspiring bloggers. Appreciate it!

  2. vurtil opmer

    A person essentially help to make seriously articles I would state. This is the first time I frequented your website page and thus far? I surprised with the research you made to create this particular publish amazing. Wonderful job!

Comments are closed.