Download Files:
https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT644-646.xlsm

See how to create a formula to add a column of categories using the functions VLOOKUP, RIGHT, LEN, SEARCH:
1. Extract partial text from style description using RIGHT, LEN, SEARCH functions
2. Use VLOOKUP to look up category and fill column in data set.