Filter (Search (Wildcard match) )

I want to Filter a table where Job Location starts with either "US-NY, US-ME, US-VT" - although I have 8 categories with up to 13 locations in one of the categories.

The "problem" (as I can see it) is that the filter criteria is the full title, and I only want to partial match to anything in the list.

I actually have it working if I statically define in the formula all of the criteria it can be: {"US-NY", "US-ME", "US-VT"}. However when I try to move those values into a table so I can build out the criteria dynamically and make it more readable, I can't seem to get it to work.

Here is what I have: FILTER(sheet!A:L, BYROW(SEARCH(Table1[NEUS], sheet!J:J, ISNUMBER))

So I want to filter columns A:L, but to determine which rows to include I want to look up each row to see which column it will match (one of the 8 categories mentioned above).

However, column J will look like US-TX-Beaumont, US-LA-Monroe, or US-ME-Brownville etc. So the criteria will have MORE info than the lookup table, and so I effectively want the lookup table to have a wildcard on it, and any full location will match to one of those categories.

Right now I'm just trying to get it to work to match a single column and then I was probably going to use a SWITCH statement, however if there is a more efficient way to figure out which column it's in rather than having 8 lookups then even better.

Lookup Table:

Data:

Disclaimer: This is a simplified version of the data vs lookup table and it is not strictly determined by the first 5 characters of the string.

And on separate sheets I want one that filters everything for NEUS, different sheet for US N, and different sheet for US S.

Let me know if anything I've described is confusing.