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"]
440000299900-163
[/td]440000451400-163
[/td]440000291600-1001
[/td]440000291800-1001
[/td]440009308400-1001
[/td]440009308500-1001
[/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"]
Product
[/td]Location
[/td]Partner location
[/td]Quota
[/td]
[TD="align: right"]440000299900
[TD="align: right"]163[/TD]
[TD="align: right"]8500[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]440000451400[/TD]
[TD="align: right"]163[/TD]
[TD="align: right"]8500[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]440000291600[/TD]
[TD="align: right"]1001[/TD]
[TD="align: right"]8602[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]440000291800[/TD]
[TD="align: right"]1001[/TD]
[TD="align: right"]8602[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]440000292300[/TD]
[TD="align: right"]1001[/TD]
[TD="align: right"]8602[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]440000451400[/TD]
[TD="align: right"]1001[/TD]
[TD="align: right"]8602[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]440009308400[/TD]
[TD="align: right"]1001[/TD]
[TD="align: right"]5380[/TD]
[TD="align: right"]95[/TD]
[TD="align: right"]440009308500[/TD]
[TD="align: right"]1001[/TD]
[TD="align: right"]5380[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]440000067400[/TD]
[TD="align: right"]1009[/TD]
[TD="align: right"]163[/TD]
[TD="align: right"]100[/TD]
[/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]
[/TABLE]