Index a result which is the value above a threshold in a time range on a date

Hi,

Seeing if anyone can help me here as my Excel skills are average at best!

I am looking for a formula to do the following:

Display the specific time when a value crosses a set threshold for the first time within a specific timerange on a specific date.

My research had prodouced the formula below so far:

=IFERROR(INDEX($B$2:$B$28,MATCH(TRUE,($A$2:$A$28>G2)*($B$2:$B$28>=D2)*($B$2:$B$28<=E2)*($C$2:$C$28=F2),0)),"No match")

The columns on my sheet are A is list of values, B List of times, C List of dates, D Start time, E End Time, F Specific date, G is Threshold value.

This may be totally wrong im not sure. All I know is it doesnt work.

I have attached the sheet with all this in.

Any help appreciated

Many Thanks Ross