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

[JohnTopley]

This ?

in D17

=INDEX($E$3:$M$12,MATCH($B17,$B$3:$B$12,0),ROWS($1:1))

in E17

=INDEX($N$3:$N$11,MATCH($B17,$B$3:$B$11,0))*$D17

in F17

=INDEX($AD$3:$AL$12,MATCH($B17,$B$3:$B$12,0),ROWS($1:1))

[chandu10787]

Thanks, John for the Quick response.

The region might change and it will not remain constant, can I have 2 match functions? one to match the employee and one to match the region?

Kindly Help

[JohnTopley]

No idea what you want: see attached

[kvsrinivasamurthy]

It is better to include few (3 or 4) sheets from which you are taking data for calculation.