Thread: VLOOKUP + IF ?
View Single Post
  #1   Report Post  
Old November 18th 20, 08:26 PM posted to microsoft.public.excel.misc
Amy H Amy H is offline
external usenet poster
First recorded activity by ExcelBanter: Nov 2020
Posts: 1
Default 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!