Match List with Filter

  • Hi,


    I just joined this site, so I am sorry if I do not quite know all the conventions of asking for help.


    Anyways, so I have a list of product code and location code separated by a dash like this: (random example)


    [TABLE="width: 233"]

    [tr]


    [td]

    440000299900-163

    [/td]


    [/tr]


    [tr]


    [td]

    440000451400-163

    [/td]


    [/tr]


    [tr]


    [td]

    440000291600-1001

    [/td]


    [/tr]


    [tr]


    [td]

    440000291800-1001

    [/td]


    [/tr]


    [tr]


    [td]

    440009308400-1001

    [/td]


    [/tr]


    [tr]


    [td]

    440009308500-1001

    [/td]


    [/tr]


    [tr]


    [td]

    440000067400-1009


    And basically I want to find the specific product and location code in the table and paste some result from a column in front of the previous combined list.


    This is the table: (random example)
    [TABLE="width: 429"]

    [tr]


    [td]

    Product

    [/td]


    [td]

    Location

    [/td]


    [td]

    Partner location

    [/td]


    [td]

    Quota

    [/td]


    [/tr]


    [tr]


    [TD="align: right"]440000299900

    [/tr][/td][tr]


    [TD="align: right"]163[/TD]
    [TD="align: right"]8500[/TD]
    [TD="align: right"]100[/TD]

    [/tr]


    [tr]


    [TD="align: right"]440000451400[/TD]
    [TD="align: right"]163[/TD]
    [TD="align: right"]8500[/TD]
    [TD="align: right"]88[/TD]

    [/tr]


    [tr]


    [TD="align: right"]440000291600[/TD]
    [TD="align: right"]1001[/TD]
    [TD="align: right"]8602[/TD]
    [TD="align: right"]100[/TD]

    [/tr]


    [tr]


    [TD="align: right"]440000291800[/TD]
    [TD="align: right"]1001[/TD]
    [TD="align: right"]8602[/TD]
    [TD="align: right"]76[/TD]

    [/tr]


    [tr]


    [TD="align: right"]440000292300[/TD]
    [TD="align: right"]1001[/TD]
    [TD="align: right"]8602[/TD]
    [TD="align: right"]100[/TD]

    [/tr]


    [tr]


    [TD="align: right"]440000451400[/TD]
    [TD="align: right"]1001[/TD]
    [TD="align: right"]8602[/TD]
    [TD="align: right"]100[/TD]

    [/tr]


    [tr]


    [TD="align: right"]440009308400[/TD]
    [TD="align: right"]1001[/TD]
    [TD="align: right"]5380[/TD]
    [TD="align: right"]95[/TD]

    [/tr]


    [tr]


    [TD="align: right"]440009308500[/TD]
    [TD="align: right"]1001[/TD]
    [TD="align: right"]5380[/TD]
    [TD="align: right"]100[/TD]

    [/tr]


    [tr]


    [TD="align: right"]440000067400[/TD]
    [TD="align: right"]1009[/TD]
    [TD="align: right"]163[/TD]
    [TD="align: right"]100[/TD]

    [/tr]


    [/TABLE]



    So I want to find the product and location in this table, and get their partner location and paste that value in front of the item-loc combined list.


    A little caveat is that some same item and location combination have multiple partnering locations and I need to take the partnering location with the highest Quota value.


    Please let me know if this made sense and how I can best achieve my desired result.


    Thank you.


    [/TD]

    [/tr]


    [/TABLE]