Excel2013 - Student Schedule Template Query.

[Kenn]

I have been playing around with the Excel Student Schedule Template to determine how it works. I get most of it, but there is some witchcraft in here that has me stumped & I could use a little help! I'm using Excel 2013. To find the template, go to New & select Student Schedule from the featured templates.

1. Open the Class Schedule worksheet & select any cell. Go to formula bar & change something in the formula, e.g. delete the last bracket, then re-type the bracket so the formula is as it was. You will notice that the formula text is now visible in the cell & the formula no longer works. How is this possible?
2. The formula uses a combination of INDEX, MATCH, SUMPRODUCT with Tables & Defined Names to populate the cells e.g.

   =IFERROR(INDEX(tblClassList,MATCH(SUMPRODUCT((tblClassList[DAY]=tblSchedule[[#Headers],[FRIDAY]])*($B23>=tblClassList[START TIME])*($B23<=tblClassList[END TIME]),tblClassList[UNIQUE]),tblClassList[UNIQUE],0),2),0)

   How does this part work

   (tblClassList[DAY]=tblSchedule[[#Headers],[FRIDAY]])

Thank you
Kenn.

​