Example of in Index/Match Function

Here I have a table with employees work hours spread over a 7 day week. The employees are on the rows and the days of the week in the columns.  I have created two criteria cells, one for the employee and one for the days.  I then created another cell which is where I will enter my index and match fuctions to automatically find out the hours worked when the criteria cells are populated.  To make this more attractive I have added a combo box using the data valadation feature to enter the criteria as below;

 

 

 

 

Here is the example of the function I used to achieve this result.

=INDEX(C3:J9,MATCH(D12,B3:B9,0),MATCH(D13,C2:J2,0))

For your reference Monday is in cell B2 and John is in cell C3