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!