Formula to calculate pay depending on job code rates

Screen Shot 2018-09-25 at 14.51.12.png

Hello,

I am new to this forum and very new to Excel as well... So I apologise in advance if this question sounds stupid.
I have been struggling all day with the table attached.

I am struggling terribly to find the formula to enter in Column F (Pay).

In column C, I enter the job code the person is doing that day.
In column D, I enter the number of hours the person is doing that day.
On the right (on my spreadsheet this is actually in a different sheet, but I moved it here just so it could be seen in the attachment), I have a table that states what is the hourly rate of pay for each different job code.

So basically, in column F I want the formula to do the following: calculate the pay for that line multiplying the accurate rate (depending on job code in column c) by the number of hours worked (column d).

I hope that makes sense

I would be forever grateful for any help you can give me, as I am completely stuck at the moment!

Hello and welcome to the forum.

Try something like this in F4:

=D4*INDEX(I$11:I$17,MATCH(C4,H$11:H$17,0))

By the way, I hope you aren't planning on using the dates in column B for anything. Merged cells do not work well with analysis.

It works perfectly, thank you so much!

And no worries for the dates, I am not planning on using them for anything

Thanks for saving my day!

You're welcome. Happy to help.