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! 

-Mary 

By: Mary

Leave a Reply

Your email address will not be published. Required fields are marked *