Index and Match query?

[Chris2022]

Hello everyone, I have a table that lists maximum time behind the wheel each day for truck drivers, depending on their individual tour. What I am trying to do is this: if a particular driver starts today at a particular time, I want to enter what I would believe to be an index and match query, to find the maximum hours they can spend behind the wheel each day, depending on how many days their current tour is. As an example, driver A starts today at 15:45, and has a 3 day tour, in the table, this is a starting time between 15:30 and 15:59, then moving across that row, find the 3 day column to get the answer of "Not allowed". All suggestions greatly appreciated. Unable to use XL2BB, find sample photo attached

.

 

[bebo021999]

With H2 and I2 is time and date criteria, try in J2:

=LOOKUP(H2,$A$2:$A$12,INDEX($C$2:$F$12,,MATCH(I2,$C$1:$F$1,0)))

 

[Chris2022]

With H2 and I2 is time and date criteria, try in J2:

=LOOKUP(H2,$A$2:$A$12,INDEX($C$2:$F$12,,MATCH(I2,$C$1:$F$1,0)))

View attachment 63148

Worked perfectly! Greatly appreciate your prompt response and sharing your excel skills to solve my problem. Thank you bebo021999.