Slicers

DaleWilson 

I just want to make sure that you're aware not only of slicers but also of the recently introduced FILTER and other "Dynamic Array" functions.

From your description of what you're trying to do, I think it's entirely possible that you'd be able to accomplish it with FILTER. It allows you to use criteria from multiple columns as the basis for the filtering it does..... And you can do it on a separate sheet in the same workbook quite easily (thus creating a form of Dashboard, extracting data from the larger table based on current need).

Is the spreadsheet you have one you can share or does it contain lots of confidential info (if the latter, then it should be rendered anonymous before sharing)?

Here's a link to a YouTube video that explains and demonstrates the dynamic array functions, if you'd like to just pursue it on your own. https://www.youtube.com/watch?v=9I9DtFOVPIg