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)

Attached Images

Unavngivet.jpg (167.3 KB, 17 views)

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.

This is the best i can do.

This is the best i can do.

And thank you

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

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

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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

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