Index Match Match using dates and times

[Seba Robles]

Hello all,

I'm having trouble trying to come up with a formula that allows me to do the following...

I have a GOOGLE SHEET with a table that lists activities by date and time assigned to a group.

On the second sheet I have a "calendar view" that is supposed to visually show how the activities by group stack on each date.

The screenshot below is the desired outcome. I can't find a formula that matches the date on row 3 with the times on column A.
Aside from that, after the match is found, I would like the cells to populate with the respective duration of the activity.

For example, if we look at activity A from group A1 on the table above, it is scheduled for 6/26, starts at 8am and ends at 8:30am. On the calendar below, cells B4, B5 get populated with that information from the table.

P.S. I used conditional formatting to paint the cells in blue for A1, purple for A2, and red for B1.

Would appreciate any pointers. Let me know if more info is needed.

Thanks in advance!!

 

[Peter_SSs]

I have a GOOGLE SHEET

That being the case, I am moving your thread out of the Excel Questions forum and into the forum that is for (among other things) Google Sheets questions.

 

[Seba Robles]

@Fluff @Peter_SSs can we close this Google Sheet post and open the Excel one instead?

 

[Fluff]

Why your images clearly show you are NOT using Excel.
Also the fact that something might work in Excel does not mean it will work in Sheets.