Forum Discussion
Data validation range based on another cell contents
Split the min and max values into separate columns:
Next, select D5:D10.
On the Data tab of the ribbon, click Data Validation.
Select Decimal from the Allow drop down, and between from the Data drop down.
In the Minimum box, enter the formula =VLOOKUP(C5,$C$15:$F$20,3,FALSE)
In the Maximum box, enter the formula =VLOOKUP(C5,$C$15:$F$20,3,FALSE)
If desired, activate the Input Message and Error Alert tabs and enter appropriate messages.
Finally, click OK.
See the attached workbook.
Split the min and max values into separate columns:
Next, select D5:D10.
On the Data tab of the ribbon, click Data Validation.
Select Decimal from the Allow drop down, and between from the Data drop down.
In the Minimum box, enter the formula =VLOOKUP(C5,$C$15:$F$20,3,FALSE)
In the Maximum box, enter the formula =VLOOKUP(C5,$C$15:$F$20,3,FALSE)
If desired, activate the Input Message and Error Alert tabs and enter appropriate messages.
Finally, click OK.
See the attached workbook.
