-
1 Attachment(s)
Criteria based lookup
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
-
Could this be done with pivot tables instead?
-
1 Attachment(s)
Note:
Commitment Brand: 234, has No Commitment: abc415
-
let me check and revert back Mr. Arnlegp, it seems like this is something which i was looking for , Thank you