Hello All,
need help with a work flow
I am going to add a checking and replacing section in my workflow. In my raw data , the sub-products which is under the main products list under the same column header as the main products , I have already split them.
Now I create a separate sheet about list of main & sub products to add a checking and replacing step in order to convert the sub product name to the main product name.
I have over 10 main products and over 500 sub products under them, the single formula I built is not suitable for this, since asking for help , thank you.
Here is the example:
the sample products (main & sub) category sheet I created:
| Main | Sub |
| A | a |
| A | b |
| A | c |
| B | x |
| B | y |
| B | z |
| C | ab |
| C | cd |
| C | ef |
| C | gh |
| C | ij |
| D | abc |
| D | bcd |
| D | efg |
| E | aaaa |
| E | bbbb |
| E | cccc |
2. the filtered data:
| Company | Product | Sales | ID |
| A1A | b | Marry | 123456 |
| A1A | x | Peter | 234567 |
| A1A | y | John | 345678 |
| B2B | efg | Amy | 456789 |
| B2B | aaaa | OK | 567890 |
| C2C | b | Hello | 112233 |
| C2C | x | Hi | 223344 |
| C2C | ab | Jack | 334455 |
| C2C | cd | Rose | 445566 |
3. Expected Result
| Company | Product | Sales | ID |
| A1A | A | Marry | 123456 |
| A1A | B | Peter | 234567 |
| A1A | B | John | 345678 |
| B2B | D | Amy | 456789 |
| B2B | E | OK | 567890 |
| C2C | A | Hello | 112233 |
| C2C | B | Hi | 223344 |
| C2C | C | Jack | 334455 |
| C2C | C | Rose | 445566 |
Attached file is the data shown above.
Thanks again
