Lookup if Time Between

[SofaQueen]

Hi there!

I'm lost trying to figure out which formula to use in order to get a shift result (1 or 3) after data is entered into an "area" column and a "time" column.
In my lookup table are the 5 areas & min/max times for shift 1. I have not entered values for a shift 3 as what is not 1 is 3. Please note the "time" column is just numbers for lookup - not formatted as time.

I can apply the IFs, but am not looking for a huge nested formula to tie in the area. So I think the answer is to look up the area, then generate an IF <> ?


Any help is appreciated!
Regards,
SQ