I have a spreadsheet with 3 worksheets..........Summary, Data Export and Lookup Tables
Here is what I am trying to do............with a formula.
On the Lookup Tables worksheet I have created 3 drop down lists that I can select values from. The DDLs are in cells I2, J2 and K2.
Once I have made my selections, I want to filter data in the Data Export worksheet to meet the conditions for the 3 values I have selected.
I am having trouble determining if there is a function that I can use in a formula to do this.
Here is what I am trying to do............with a formula.
On the Lookup Tables worksheet I have created 3 drop down lists that I can select values from. The DDLs are in cells I2, J2 and K2.
Once I have made my selections, I want to filter data in the Data Export worksheet to meet the conditions for the 3 values I have selected.
I am having trouble determining if there is a function that I can use in a formula to do this.
