VLOOKUP + IF ?
Does anyone know how to use Vlookup and If function together?
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
Seems pretty basic but can't figure out how.
Thanks in advance!