Cost allcocation ...

vaxo magularia
vaxo magularia used Ask the Experts™
on
I need the cost to allocate in yellow filed with the helper column that is g columns please help thanks, i advanced.
cost-allcoation1.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
Please find attached...
cost-allcoation1_v1.xlsx

Author

Commented:
Yes but answers are incorrect A column and B column also must be participated
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
Check your initial question  
I need the cost to allocate in yellow filed with the helper column that is g columns

Let me correct it
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018
Commented:
Please find attached:
cost-allcoation1_v1.xlsx
Finance Analyst
Commented:
This formula can be used in all yellow cells:

=VLOOKUP($A21,$A$5:$B$10,2,FALSE)*(VLOOKUP($G21,$A$13:$F$16,MATCH(B$20,$A$13:$F$13,0),FALSE)/VLOOKUP($G21,$A$13:$F$16,MATCH($F$20,$A$13:$F$13,0),FALSE))

Copy from above and paste into one yellow cell, eg B21 and then drag right and down as required.

See attached

Thanks
Rob
cost-allcoation1.xlsx

Author

Commented:
Thanks this formula works

Author

Commented:
Thanks Shums this also works thankss...
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
If it works, I request you to please close the question. Thanks

Author

Commented:
How to close??
Rob HensonFinance Analyst

Commented:
At the bottom of each of the suggestions there will be two buttons:

Best Solution and Assisted Solution.

Click the Best Solution on the suggestion that you want to accept to start the process. You can then add an Assisted solution if so desired.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial