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.


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