Hi there,
I'm trying to group a database of over 20,000 products into 43 group types. Several groups sit within departments, which I have already manually specified for each of the products.
Given the time it would take to manually group these products, I'm trying to figure a formula that first checks the department number (between 1 and 9), then checks for keywords in the item description to apply a group number to it.
For instance, if a product was called 'Vitamin C Tablets 100s' it would already be in department 1 for 'vitamins and supplements' so the formula would check this, then check against a list of keywords I have in order to assign the correct group ID, so for instance, it would check against keywords like 'capsules' 'tablets' 'tablet' 'caps' 'capsule' 'tabs' and if it matches any of these, it would display a number '1' in the cell to represent the 'capsule/tablets' group.
I know this requires a nested IF formula, but I have been trying to create one that works all morning with no luck. Any ideas would be massively appreciated.
I have attached a sample spreadsheet for how the data should look.
Thanks in advance Sample Sheet.xlsx
Bookmarks