kalakriti
09-28-2022, 10:03 AM
Hello
looking for a suitable lookup formula for the below problem
I have ten sites and around twenty five brands. Five commitment numbers , having certain percentage of charges , I need to allocate that percentage across different site and brand combination based on the commitment numbers.
I am attaching the excel work sheet along with the expected solution. Expected Solution [ I need a formula in cell E164 to I73] which will pick up charges based on commitment no / brand and site number. I will have 25 tables similar to this in which only the brand numbers will change , based in which the charges also should change
Thanking in advance
looking for a suitable lookup formula for the below problem
I have ten sites and around twenty five brands. Five commitment numbers , having certain percentage of charges , I need to allocate that percentage across different site and brand combination based on the commitment numbers.
I am attaching the excel work sheet along with the expected solution. Expected Solution [ I need a formula in cell E164 to I73] which will pick up charges based on commitment no / brand and site number. I will have 25 tables similar to this in which only the brand numbers will change , based in which the charges also should change
Thanking in advance