Luigi802
New member
- Joined
- Aug 29, 2016
- Messages
- 12
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
So if you look at the attached sheet, I want to make some kind of VLOOKUP formula or any formula what would enter the correct category/sub category on the DATA sheet based on if the contents the the description "contain" data in the description column on AutoCat sheet....for example on line 15 on the DATA sheet, it says "BLUE RIDGE COMM CABLE BILL ***********2001" and on the AutoCat Sheet on line 3 it just says Blue Ridge, how could I make the category and sub category automatically fill in on the DATA sheet based on the data in the Auto Cat sheet?