Excel Forum
Similar Content
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...
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
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...



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.