Excel Forum
Similar Content
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...
Remove All Data Validation from a Cell in Excel
Macro: Remove all data validation from a cell in Excel with this free Excel macro. This is a grea...
Add a Drop Down Menu to a Cell in Excel - Data Validation Macro
Macro: Add a drop down menu or list to a cell in Excel with this free Excel macro. This is a grea...



Excel Magic Trick 335: VLOOKUP & Data Validation for Recipes


See how to take recipes listed in a column, set them up in rows, then create a drop down arrow to select recipes and display ingredients and directions.

See how to increment column numbers for a VLOOKUP lookup table when you are copying the formula down across the rows (down a column).





Got a Question? Ask it Here in the Forum.