• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Index Match Breakdown of Expenses based on hours and project

excelnovice2000

New Member
Hello Gurus,
I am trying to breakdown each employee gross wages and other employer costs based on the number of hours each employee worked on a specific project

As an example
If employee Iron Man has gross wages of $3,125.00 and has worked on 4 different project and his hours worked are 31 hours. I want to breakdown the $3,125.00 to the 4 different projects based on 31 hours

Employee Gross Wages and other data is in Data tab. I have highlighted the expected result in green color in Sheet2 tab.


Really appreciate your help
 

Attachments

Top