Forum Discussion
Osvaldo Panguane
Jul 06, 2018Copper Contributor
Calculate hours Percentage of different employees with variable total (long employees list)
Hi all, Is there anyone who can help me to overcome this issue. I have a large employees list and I would like to Calculate hours Percentage of different employees with variable total. Employee...
- Jul 24, 2018
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)
Osvaldo Panguane
Jul 24, 2018Copper Contributor
Matt Mickle
Jul 24, 2018Bronze Contributor
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)
- Osvaldo PanguaneJul 24, 2018Copper Contributor
Thanks a lot.
Osvaldo