Populating a wage based on a drop-down list

[MDHolmes]

I'm pretty much self-taught on Excel, and I'm really having trouble with this...

I have two worksheets in my spreadsheet, the first is Labour Tracking, the second Data.

My Data worksheet has a list of seven employees in Column A and their corresponding wage in Column B. The number of employees could go up to ten.

My Labour Tracking worksheet has a dropdown list that's populated from 'Data'!A1:A7. I did that formula successfully : )

I already have a formula in Column S that would multiply Column Q (Time) by whatever the wage is, but I've been manually entering the wage up to this point because I don't know what formula to use. That's a pain :-/ and I'd love to not have to do my own math - Isn't that what Excel is here to help me with?

So my question: I'd like the Wage column (R) on the Tracking worksheet to autopopulate with corresponding worker's wage once an employee is selected from the drop-down list. Is this possible?

If I could figure out a way to do this, then I could also use an IF statement to calculate the total wages for each employee on a particular job, which would be awesome! I'm pretty sure I've got that formula figured out. Just not this one :-/

Thank you so much for any assistance you can provide!!

 

[MDHolmes]

No.... so Mike in row 10. He worked say, April 3, for 2 hours at this job. His rate was $33/hour. His total for that day was $66.
Row 17 has him working April 12 for another 2 hours. $66 that day.
Finally in Row 24, he's worked 8 hours on April 14 for a total that day of $264.00

The guys will be working on this project for another 2 months, so there will be more entries.
I want to be able to calculate each guy's total billable amount (ie. Apr 3, Apr 12, Apr 14 (66+66+264)) using a formula.

I'm sorry I'm not making it clear :-/

 

[jtakw]

You are making it clear, That's Exactly why I asked, so we should be adding up Column S, Not Column R.
Column R is just their "hourly" rate, Column S is the Total (hours x hourly wage).

I'm basing these question on your picture in Post #7, so unless you've changed the layout since, we should be using Column S:

Use this formula in AB10, copied down, Do not remove the $ symbols in my formula:

=SUMIF(P$11:P$26,AA10,S$11:S$26)

 

[MDHolmes]

Oh my word... yes. I do mean Column S. I guess I'm tired!

 

[MDHolmes]

You are making it clear, That's Exactly why I asked, so we should be adding up Column S, Not Column R.
Column R is just their "hourly" rate, Column S is the Total (hours x hourly wage).

I'm basing these question on your picture in Post #7, so unless you've changed the layout since, we should be using Column S:

Use this formula in AB10, copied down, Do not remove the $ symbols in my formula:

=SUMIF(P$11:P$26,AA10,S$11:S$26)

Thank you so much!! That worked perfect and calculated exactly what I wanted. You're a huge time-saver!
Big hugs to you ??