Hi,
I recently was provided a nice solution for an index-match problem I had. I now have run into another problem and I believe this one is quite advanced.
I would like an index-match formula that contains multiple criteria, but one of the criteria is only applicable if the user specifies so. For instance, I want to return data between two dates, BUT if the user chooses to further filter the data, then the second criteria is used. I'm not quite sure how to implement this.
In my attached example:
I have a column of raw data. Data includes, date, temperature, oven type.
User inputs two dates, and the index formula returns data only in those dates. However, if the user chooses "y" for "filter by oven type?" then the data is further filtered by the oven type.
The attached shows both results of what I am trying to achieve.
Thank you for your time.
Bookmarks