Splashing the numbers based on past average

[achu3186]

Good Day all,

I am trying to allocate the May projected cost (H2) into country level (H4:H16) based on the country average of last month actual (F4:F16).
The country average should be the same as Actual April for May. File attached for your easy reference.

[achu3186]

Can anyone help me on this?

[AliGW]

What do you mean by "splashing the numbers"? Explain your sample data and your expected results.

[achu3186]

Thanks for your response and apologize for the confusion.

I mean H2 is my total projected cost for May. I would like to allocate this cost in to country level based on the April cost/box.
If I allocate this cost based on the May boxes, I am getting different cost/box for May.

Note : My idea is to keep the same April cost/box for all countries since I don't see any variations in the market condition.

[JeteMc]

The country average should be the same as Actual April for May.

If this means that the values in column I should be the same as the values in column F then try pasting the following into cell H4 and copying down: =G4*E4/D4
If that doesn't produce the desired values, then it may help if you could tell us how you would fill column H manually, so that we can attempt to come up with a formula/code that will produce the same results.
Let us know if you have any questions.