Please forget about #8. By mistake I forgot to change semicolons (which is my usual setting) in the last formula to commas.

I also think I misread your last words:

and time in between to times

Try this formula instead:

=INDEX(C18:AH18,MATCH(B23,INDIRECT(B24,0),1))

If you want to avoid the helper cell you can try this formula:



=INDEX($C$18:$AH$18,MATCH($B$23,OFFSET($C$1,MATCH( $B$22,$B$2:$B$17,0),,,32),1))

Thank you so much