I have a sheet with data, theres a section laid out 8x9 with a layout approximately similar to below (didn't recreate all 9 rows):
I am trying to set up a front page where my less savvy colleagues can access specific data from other columns (not these shown) based on their requirements.
So, from a range of 8 dropdowns (or checkboxes) that correspond to the headers above, my colleague might select yellow and orange. In this example I would desire the return to be the second and third row of data as they both have yellow and orange.
I can't seem to figure out how to set something up to filter or query ONLY selected columns and ignore those that aren't indicated in dropdowns. Everything I've gotten to work has required an exact match of all columns being either true or false. I need to search or query only the selected columns.
Am I making sense?