Forum Discussion
Calculate hours Percentage of different employees with variable total (long employees list)
Please see screenshot for reference. I would try using an Hlookup with a few reference numbers that are set up based on the number of repetitions:
=HLOOKUP(I8,$E$9:$G$10,2,TRUE)
Please see the attached file for reference. It looks like you are receiving some type of standard payroll report. If you have any influence on the report format I have attached the ideal report output that would allow you to easily accomplish your task. If you can get a report in that format then you can use a simple pivot table to get to your end goal. Otherwise, I have attached a few formulas that will work for your current set up:
Please see screenshot for reference. I would try using an Hlookup with a few reference numbers that are set up based on the number of repetitions:
=HLOOKUP(I8,$E$9:$G$10,2,TRUE)
Thanks a lot.
Osvaldo
