A Complicated Calendar Project with array formulas

[TurtleRocket]

Hello!

How would I get the name of the event from the Events List to show in the cells at which it takes place at in the Weekly Calendar tab?? </SPAN>
</SPAN>
I would like for the Events List-table to have the events listed show in the weekly tab, during the time they take place, narrowed down to 4 categories(Product Launches, Meetings, Training and Other). But for the “Other” category to have it show with the "Other" Color assigned to it with what the actual event is. </SPAN>
</SPAN>
I would also need the Product Launch, Meeting and the Training as well to state what kind of; training, product launch, meeting would take place during the event time in the weekly tab. I have added a new column in the events list that states Event Name...if this helps? </SPAN>
</SPAN>
What formula would be used?? Would it be a LOOKUP function...IF THEN ELSE statement for a VBA code or IFERROR function? What formula would need to be in the Events List tab to make this work and have it pull it to the weekly showing the "event name"?</SPAN>
</SPAN>
I don’t really want the start and end times listed in the event...but the Event Name...but how given the formula below?</SPAN>
</SPAN>
=IFERROR(INDEX(CSEvents,MATCH(TEXT($C9+E$6,"mmddyyyhh")&$M$3,TEXT(CSEvents[[Start]:[Start]],"mmddyyyhh")&CSEvents[[Kind of Event]:[Kind of Event]],0),2),IFERROR(INDEX(CSEvents,MATCH(TEXT($C9+E$6,"mmddyyyhh")&$M$3,TEXT(CSEvents[[Finish]:[Finish]],"mmddyyyhh")&CSEvents[[Kind of Event]:[Kind of Event]],0),3),""))</SPAN>
</SPAN>
I need seven events to show each day in the weekly tab vs the 4 that are currently in there?</SPAN>


Calendar Project 1.xlsm

Thank you for any help you can provide!

 

[TurtleRocket]

I have come a little bit on this project and need help, please. Now all I need to know if the formula needs to be a Countifs or and IFERROR9INDEX(MATCH of some sort. The COUNTIFS formula listed above lists the times within the duration of the event, but I am also trying to get the Event name to show as well.

Below is the updated worksheet:

https://drive.google.com/file/d/0B2cIkkORjHDDMFdZN2xYemN4VDQ/edit?usp=sharing

Thank you!