VLOOKUP + IF ?
Am Wed, 18 Nov 2020 11:26:29 -0800 (PST) schrieb Amy H:
So if A contains a certain word, it will pull out the category from another category table (C=categorize, D= the word)
If A contains word "CPC", then I would like to have it categorized as "Shipping" next to the word "CPC".
CPC l Shipping
Pen l Office supplies
In the newer version you also could use: