Multiple Lookups to get result

[coach.32]

Hi everyone. I have attached a sample spreadsheet with the required data and the outcome I need in bold.
I need to pick out a cost from one column based on the selections made in Columns A, C and D.
I assume it would be an INDEX/MATCH formula, but that's where it ends for me.
Could someone advise what the formula would be?
If I Select the Day, the time worked and the level of the person, I would like the formula to look up the corresponding Rate in the columns of Rates on the right of the spreadsheet.
Thank you for your assistance/answers.

[Haseeb Avarakkan]

Based on your sample file, this works,

=SUMPRODUCT((G$2:G$19=TEXT(B2,"dddd"))*(H$2:H$19=C2),INDEX(I$2:N$19,0,MATCH(D2,I$1:N$1,0)))

[Tony Valko]

Try this array formula** entered in E2:

=INDEX(I$2:N$19,MATCH(1,IF(G$2:G$19=TEXT(B2,"dddd"),IF(H$2:H$19=C2,1)),0),MATCH(D2,I$1:N$1,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.