Hi Guys
This one has been boggling my brain and I am hoping I can even describe what I am trying to do, to give anyone the opportunity to try and suggest a solution.
I have exported a lot of product data from our old system and we have a lot of products that are made up from products in the same list.
E.g.
Product 100, 101, 102, 103 and 104
These are each individual products, however product 100 is made up of 102 and 103, 104 is made up of 100 and 101 etc etc.
I have column A which is the product number
Column B is the UPC/GTIN of each product.
Colulmn C is a space separated list of any UPC/GTIN numbers that that product is used in.
Part Number| UPC Number | Used in assembly
Product 100 | 1234567890 | 1928374650 9876543210 7654920178
Product 102 | 1325465768 | 1928374650 9766654310 1888375655 1193756665
etc
I am hoping to search to see if the UPC number for each product is located in any cell in the Used in Assembly column. If it is the part number for the UPC number should be added to a column in the matched UPC number value found in the used in assembly column.
It would result in this
Part Number | UPC Number | Component 1 | Component 2 | Component 3 etc
Product 176 | 1928374650 | Product 100 | Product 102 |
Product 176 is made up of product 100 and 102, as its UPC number was found in the 'Used in assembly' column for each of the other two products.
I hope that made some sense.
Please let me know if I can clarify anything of explain further.
Thanks in advance.
Regards
Jonathan
Bookmarks