Looking for a Function

[JEC8878]

Hi

Please could someone help me find a function - on attached sheet there is a table on the formatted tab and on sheet one is Times broken down into periods and named. I'm wanting to put a formula in column M on formatted sheet that will tell me if the time falls between the times and will pull through the name eg, Breakfast, Lunch, etc.

 

[AliGW]

Please add 10-15 rows of expected results manually to the results sheet. I do not understanbd what you want to see in column M, nor which of the four columns of times are relevant. Add some explanatory notes next to your expected results.

 

[JEC8878]

Hi
Sorry im not too good with explaining things - i have added what i want to see into column M. The times i need this to reflect against are the planned start / End times which i have highlighted.
Eg, so if the planned start / end times are 09:00 - 09:30 then this would pull through breakfast into column M from the additional sheet within the workbook.
Hope this makes a bit more sense.
I have uploaded an amended copy

 

[AlanSidman]

In M2 =XLOOKUP(Table1[@[Planned_End_Time]],Sheet1!$B$3:$B$10,Sheet1!$C$3:$C$10,,1)

 

[JEC8878]

Amazing thank you so much