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...
Require a Unique List of Numbers in a Range in Excel
Tutorial: I'll show you how to require a user to enter a unique number into a range of cells in Exce...
Prevent Cells from Summing to a Negative Value or Vice Versa
Tutorial: How to prevent a range of cells from adding up to a negative value, or preventing the same...



Excel Magic Trick 675: Double VLOOKUP Custom Formula Dynamic Data Validation


See how create a data validation using Custom Logical Formula with 2 VLOOKUP functions that will change when different products are entered. For example, if shirt product is entered, the data validation will let only values between $50 and $100 into the cell, but if a different product is selected, then a different range of dollar values will be used.

Download file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm





Got a Question? Ask it Here in the Forum.