|
Featured Tutorial
Featured Macro
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
Download file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm