Then D3 = index (h $3: m $3, match (small (h $ 1:m $ 1, row (a 1)), h $1:m $1))
Finally, enter = index (h $3: m $3, match (small in D 9 (h $ 1: m $ 1, 3), h $1:m $1,0). Note that the single 3 in this formula can be modified at will.
If you want to keep the table for one week after it is generated, you should copy the result and paste the value selectively in another area to delete the formula ... so that when you press the function key F9 again next week, a result will appear. ...
Pay attention to negotiate with your roommate on which day of the week to draw it.
Finally, I wish you continuous progress in your studies! Get good grades.