I have a table that I am trying to use the filter function to report the names based on last names and the priority level. Currently I am able to use the filter function to look at a specific name in a drop down but it does not do it based on priority. The list currently has 59 values and I am trying to cut down the time it takes and create an easier way to look based on the priority levels. I do have other criteria it is looking (date ranges attached to the names). I am not able to manipulate the data on Table1 due to legalities.

Right now I am using this filter formula:

=FILTER(Table1[Names],ISNUMBER(SEARCH(I1,Table1[Names])))

I’m not sure if the filter function is the best tool or if there is a better suggestion, my VBA usage is very restricted.

This is the formula close to what I am trying to get working on a sample set of data:

=FILTER(Table1[Names],ISNUMBER(SEARCH(Table2[Last],Table1[Names]))*(Table2[Priority]=I1))

So if I wanted to input “High” in I1 it would return as such: