Excel Forum



Excel Magic Trick 646: VLOOKUP to add column of categories to Apparel Data Set


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.





Got a Question? Ask it Here in the Forum.