Results 1 to 10 of 15

Thread: VLOOKUP on Matching Multiple Criteria

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Sir Moderator sandy666's Avatar
    Join Date
    May 2018
    Posts
    240
    Rep Power
    7

    Cool

    is this ok?

    Sales Man Territory Dimension Sales Amt Cost
    John New York Tissue
    1000.00
    200.00
    Alfred Washington Soda
    2100.00
    700.00
    John New York Soda
    2050.00
    1500.00
    Alfred New York Tissue
    2000.00
    500.00
    Leo Washington Soda
    200.00
    100.00
    Leo New York Tissue
    3500.00
    1500.00
    Maxwell Washington Towel
    1000.00
    800.00
    Result
    Sales Man Territory Dimension Sales Cost
    Maxwell Washington Towel
    1000
    800
    Maxwell Washington Tissue
    Maxwell Washington Soda
    Maxwell Washington Paper
    Leo New York Tissue
    3500
    1500
    Leo Washington Soda
    200
    100
    Leo Washington Tissue
    Leo Washington Paper
    Leo Washington Towel
    Leo New York Paper
    Leo New York Towel
    Leo New York Soda
    John New York Soda
    2050
    1500
    John New York Tissue
    1000
    200
    John New York Towel
    John New York Paper
    John New York Tissue
    John New York Paper
    John New York Soda
    John New York Towel
    Alfred Washington Soda
    2100
    700
    Alfred New York Tissue
    2000
    500
    Alfred New York Soda
    Alfred Washington Tissue
    Alfred New York Towel
    Alfred New York Paper
    Alfred Washington Paper
    Alfred Washington Towel


    Maxwell has one Territory so he has 4 records only

    with 2 Territories for Maxwell result will be

    Result
    Sales Man Territory Dimension Sales Cost
    Maxwell Washington Towel
    1000
    800
    Maxwell Washington Tissue
    Maxwell Washington Paper
    Maxwell Washington Soda
    Maxwell Coburg Paper
    Maxwell Coburg Towel
    Maxwell Coburg Tissue
    Maxwell Coburg Soda
    Leo New York Tissue
    3500
    1500
    Leo Washington Soda
    200
    100
    Leo Washington Tissue
    Leo Washington Towel
    Leo Washington Paper
    Leo New York Towel
    Leo New York Paper
    Leo New York Soda
    John New York Soda
    2050
    1500
    John New York Tissue
    1000
    200
    John New York Tissue
    John New York Paper
    John New York Towel
    John New York Paper
    John New York Soda
    John New York Towel
    Alfred Washington Soda
    2100
    700
    Alfred New York Tissue
    2000
    500
    Alfred New York Towel
    Alfred Washington Tissue
    Alfred New York Soda
    Alfred New York Paper
    Alfred Washington Paper
    Alfred Washington Towel


    Solution
    Last edited by sandy666; 10-24-2020 at 10:46 PM.
    sandy
    I know you know but I forgot my Crystal Ball and don't know what you know also I may not remember what I did weeks, months or years ago so answer asap. Thinking doesn't hurt

Similar Threads

  1. HELP - Vlookup based on 2 criteria.
    By amar.kshirsagar in forum Excel Help
    Replies: 7
    Last Post: 01-24-2014, 04:16 PM
  2. VLookup Any Matching Word From A Sentence
    By Vivienjohn in forum Excel Help
    Replies: 0
    Last Post: 12-30-2012, 11:55 AM
  3. VLookup Any Matching Word From A Sentence
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 12-30-2012, 11:55 AM
  4. Vlookup with multiple criteria
    By patsir in forum Excel Help
    Replies: 7
    Last Post: 08-27-2012, 11:15 AM
  5. Extract multiple data matching with input
    By excel_learner in forum Excel Help
    Replies: 1
    Last Post: 02-13-2012, 06:08 PM

Posting Permissions

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