I am trying to get my array formula to be able to filter on multiple drop down menus. I have 2 separate formulas that work but I cannot combine them. Is there a way to combine them to make the Array formula filter on multiple criteria?
Multiple filter formula:
=filter(filter(Sheet2!A1:L8, (Sheet2!A1:L1=B2)+(Sheet2!A1:L1="All")), Sheet2!A1:A8=B1)
Link to the spreadsheet updated to share with anyone: https://docs.google.com/spreadsheets/d/11rfgF8TQXeCNIkQE1Wklckdwrsu7N6Um2h_i4k1-1JU/edit?usp=sharing