# 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

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

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))

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1