One way...

Use cells to hold the criteria:

F2 = Tuesday
G2 = Shift 2

Then, this array formula** entered in H2:

=INDEX(D2:D7,MATCH(G2,IF(B2:B7=F2,C2:C7),0))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.