# calculate labor cost of different staff members with different labor rates using 1 formula

1. ## calculate labor cost of different staff members with different labor rates using 1 formula

I am trying to set up a column that can use one formula (i assume it's some sort of "multiply if" formula....) to calculate the labor cost of different staff members with different labor rates. the attached sheet highlits the cell i need the formula to go into.

I need this formula to multiply the correct labor rate (B8:B11) by the hours worked (D15:D100) depending on which staff name is in Column C15:C100--- i want it to see A8:A11 and use the corresponding labor rate from B8:B11.

any help is greatly appreciated!

Monitoring Estimate.xlsx

Thanks,
Dave  Register To Reply

2. ## Re: calculate labor cost of different staff members with different labor rates using 1 for

In cell E15, type
=D15*(VLOOKUP(C15,\$A\$8:\$B\$11,2,FALSE))

Copy down

Alan  Register To Reply

3. ## Re: calculate labor cost of different staff members with different labor rates using 1 for

try

=D15*INDEX(\$B\$8:\$B\$11,MATCH(C15,\$A\$8:\$A\$11,0))  Register To Reply

4. ## Re: calculate labor cost of different staff members with different labor rates using 1 for

Thank you both very much for the quick responses! i tried Alan's and this worked perfectly! as did Ace_xl's!

Cheers!

Dave  Register To Reply