Which formula?

New Contributor

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

1 Reply


=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.