Which formula?

[CThomson_E]

I have a table of rates as below.  

On another sheet, I would like it to select the correct rate, depending on the Trade and if Day or Night shift.

Can anyone assist with the formula?

Thanks in advance

[#2]

@CThomson_E 

=INDEX('table of rates'!$B$2:$C$18,MATCH(Tabelle1!$C2,'table of rates'!$A$2:$A$18,0),MATCH($E2,'table of rates'!$B$1:$C$1,0))

Maybe with this formula.