Filtering with dynamic criteria

[wengerj05]

I have a table that I'm filtering based on cascading dropdowns. That part all works fine unless I don't know the info and want to leave it blank. I created a complex If/Then function to do different filters based on the dropdowns, but I thought of a more elegant solution that I can't seem to get to work. My formula is two parts:

1st:
I have text that mirrors my conditions in the filter function
(Table1[MANUFACTURER]=B1)
(Table1[Phase(s)]=B2)
(Table1[Voltage (AC)]=B3)

Each of those is next to a column with a formula like =IF(B1="","",P3) where if it's blank, we return blank and if it's not, put the text in the cell.

Below that I used =TEXTJOIN("*",TRUE,Q3,Q4,Q5) to get (Table1[MANUFACTURER]=B1)*(Table1[Phase(s)]=B2)*(Table1[Voltage (AC)]=B3) in Q7

2nd:
On my filter function =FILTER(Table1,Q7,"Your choices do not match any inverter type. Please make changes and try again") I want to insert the text as my filter criteria where "Q7" is. I've tried multiple things like the T function, concat, etc, and nothing has worked.

so my question is first, is this even possible to do what I want? If so, when I text join only 2 of the options it would show (Table1[MANUFACTURER]=B1)*(Table1[Voltage (AC)]=B3) and then filter, but it doesn't.
If not, is there another way to think about this?

Would really love some help.

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

[wengerj05]

Do I have to?

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

[torachan]

If you want serious help, Yes, otherwise it could be days of speculation and crystal ball gazing.
torachan.

[wengerj05]

Fair enough. Should be attached now.