I have a question regarding searching an unordered list of data with multiple conditions. I have attached a file of what I am trying to do.
Essentially I want to search column G, total sales, for the first value that meets 2 (or potentially more) conditions.
In the example i have highlighted in yellow, I am looking to return the first date where the date is greater than April 1 AND the Total Sales exceeds 150.
I have been able to do this with a single condition, highlighted in orange (or whatever you would like to call that color). The formula I am using there is:
I just can't seem to get this to work with AND statements.
In this example there are 2 conditions, but I may like to include more in the future.
I am just looking for the simplest and most elegant way to do this.
Many thanks in advance