index / match multiple variables

Enough pulling may hair out. I need some help on this

I have attached the workbook for reference.

The difficulty is creating a formula that returns STOP TIME.

STOP TIME is to be calculated when the STOP AMOUNT is met, however the TIME needs to be after the SELECT TIME in $E$2.

For instance, highlighted in red, 9:08 is before 9:35, therefore, I need to skip this instance of 3,198.00 and find the next one. If none exist I have it set to return “No”.

Thank you in advance!

Please Login or Register  to view this content.

Ctrl+Shift+Enter

Hello again.

Now I am trying to expand this formula. In particular the (H10=OPEN) needs to include the range of >=LOW <=HIGH. Not just the OPEN value.

Thanks in advance.

Not sure what you mean. OPEN is always >=LOW and <=HIGH...???

Please elaborate.

In the formula =IFERROR(INDEX(TIME,MATCH(1,(H10=OPEN)*(A10=DATE)*($E$2<=TIME),0)),"No")

Instead of H10=OPEN

I would like to MATCH the TIME if H10 falls within the range H10>=LOW and H10<=HIGH

Hope this helps