Consulting

Results 1 to 4 of 4

Thread: Criteria based lookup

  1. #1

    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
    Attached Files Attached Files
    Last edited by Aussiebear; 09-28-2022 at 12:10 PM. Reason: Removed table layout

  2. #2
    Moderator VBAX Guru Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    4,240
    Location
    Could this be done with pivot tables instead?
    Remember To Do the Following....
    Use tags when posting code to the thread,
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  3. #3
    Note:

    Commitment Brand: 234, has No Commitment: abc415
    Attached Files Attached Files

  4. #4
    let me check and revert back Mr. Arnlegp, it seems like this is something which i was looking for , Thank you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •