GOAL:
- Google sheet searches rows for matching ZIP KEY, a zip key is the first 2 digits of a zipcode.
- As of now I filter for if ZIP KEY text match contains the ZIP KEY, BUT it does not work as a good filter for mutiple numbers.
- Zip keys are a users service area which would look like (45, 41, 43)
- If the location zip key matches any of the 3 for example then it will filter users for that key.
- The main issue I am finding is that if a zip key contains a (4) then it will send emails to all 4s regardless of the second digit 45, 41, 43. I need it to filter for both digits if it is contained in the zip key.