Need formula help

[aparvez007]

Hi,
I have two sheet in one sheet I have Total CTC for each employe in other sheet Jobwise number of hour each employee work in particular job, So I want to distribute the total CTC amount to each job. Sample fine attached with required output. Thanks in advance.

Regards,
Pavi

 

[vletm]

aparvez007
One rough sample.
Please try to figure more suitable title of thread - as written in Forum Rules.

 

[aparvez007]

aparvez007
One rough sample.
Please try to figure more suitable title of thread - as written in Forum Rules.

Thanks vletm... work fine and sorry for title next time I will use better title.
Thanks