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...
How to Add a New Line to a Message Box (MsgBox) in Excel VBA Macros
Tutorial: I'll show you how to create a message box popup window in Excel that contains text on mult...
SUMIFS - Sum Values Based on Multiple Criteria in Excel
Tutorial: The SUMIFS function allows you to sum values that meet multiple criteria across multiple ...

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.