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 VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick 334: VLOOKUP & Data Validation for Invoice


See how to use VLOOKUP & Data Validation to make an Invoice when the Product List is on a different Sheet or different Workbook. See the functions VLOOKUP, COLUMNS and IF. See Data Validation List from a different worksheet or Workbook. See how to name a range of cells. Learn about workbook & worksheet cell references in formulas.

Worksheet and Workbook References in formulas and VLOOKUP function.





Got a Question? Ask it Here in the Forum.