Two criteria search in a matrix

[Diver]

Hi i´m doing something wrong.

The last 3 days i have bin trying to get a value (red) from a row number (orange) and time in between to times (blue)

[jeffreybrown]

Hello & Welcome to the Forum,

I am not as young as I use to be, so could you post your workbook so I can see a little more clearly. That picture is small.

[Diver]

This is the best i can do.

[Diver]

This is the best i can do.

[Diver]

And thank you

[jeffreybrown]

Originally Posted by Diver

This is the best i can do.

What is the best you can do? You can't attach a workbook?

[Pecoflyer]

Click - Go advanced - Manage attachments and follow the wizard to post a sheet

[xor]

With row number (orange) in B22, time in B23 and the following in B24 (a helper cell):

="R"&MATCH(B22;B2:B17;0)+1&"C3:R"&MATCH(B22;B2:B17 ;0)+1&"C34"
you can try the following:

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

[xor]

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))

[Diver]

Thank you so much