Excel Forum



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.