Excel Forum
Similar Content
Top Excel Keyboard Shortcuts to Increase Productivity
Tutorial: I'll show you the top keyboard shortcuts for Excel that are sure to increase your producti...
SUMIFS - Sum Values Based on Multiple Criteria in Excel
Tutorial: The SUMIFS function allows you to sum values that meet multiple criteria across multiple ...
Make a UserForm in Excel
Tutorial: Let's create a working UserForm in Excel. This is a step-by-step tutorial that shows you e...



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.