Hello there,
I need help matching data . I have a time in Column A. I would like to match the time to the number in Column M e.g. in Cell A2 we have the time 9:45 am I would like to have the number 1 in Cell B2 based on the fact that in the table in Cells K2:M31 the time slot 9:45 am to 10 am has the number 1 in Cell M2 and for Cell B5 the value should be 7 because the time in cell A5 is 11:21.
Thank you so much in advance.
Bookmarks