Need help not sure on the formula to be used

[Chandu10787]

Hi Folks,

I need to show the employee cost every month as shown in the example, I get % of the allocation, cost, and hours from different sheets, Please help which formula will help me and how to avoid duplicate lines if there is no data.

Thanks
Chandu

 

[ETAF]

for allocation
=INDEX($E$3:$M$11,MATCH($B17,$B$3:$B$11,0),MATCH($C17,$E$2:$M$2,0))
for Cost
=SUMPRODUCT(($B$3:$B$11=$B17)*($Q$2:$Y$2=$C17)*($Q$3:$Y$11))
for Hours
=SUMPRODUCT(($B$3:$B$11=$B17)*($AD$2:$AL$2=$C17)*($AD$3:$AL$11))
Not sure if you are rounding up hours , as .6 is shown as 10 - looks like just a format

 

[Chandu10787]

Thanks It helped

 

[ETAF]

you are welcome

 

[p45cal]

Another approach.
It looks like you table is actually made up of 3 separate tables put next to each other.
Power Query to pivot table in the attached at cell H16.