Forum Discussion
Solved
Data validation range based on another cell contents
Hi All, I am having trouble with this one and feel like it should be easier than it is (for me) I want to have two data validation columns, Column C is whole no. 1 thru 6, Column D is a range % BAS...
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.
That explains it. AutoComplete was introduced in version 2308.
Your version is older. You'll have to wait until you are updated to 2308.
its not just me then... if this file is to be used by others, I really need to wait until ALL are updated to that vs. Appreciate the insight! Not what I was expecting nor what I like, but it is what it is and guess I am at the mercy of whatever dept controls the updates, etc. Sure it is a lovely dept wrapped in red tape