Multiply numbers with multiple condition

Hi Team,

Happy New Year!!

I require formula help in attached sheet. The formula require in cell F3 & G3 and formula should match the location & shift type and then multiple hours into "pre-rate" & "post rate" under sheet2 tab as per the location & shift type. ex in Cell F3 formula should mutilpy by cell D4 in sheet2 tab and in G3 formula should mutilpy by cell I4 in sheet2 tab.

Thanks,
Rahul