Forum Discussion
Conditional Data Validation
I have a workbook with two worksheets. The first tab is a request form for users to fill out and the second is the drop-down values.
I would like the drop-down values to change based on the value they select in column A.
In A2, they can select from 3 values (the drop down is based on a data validation list called Brand) I want column D drop-downs to populate based on the value they select in column A. I separated out all the data on tab 2, so depending on what they select in A2, they would either need to lookup to Column E or F on the second tab.
I have other similar conditional scenarios but just need helping getting started on the first one! Should I be setting up my lookup data in a different format to make this easier?
2 Replies
See Create Dependent Drop Down Lists for clear instructions, with a video, a downloadable sample workbook and links to more advanced examples.
HansVogelaar thank you, this was very straightforward and much easier than what I was trying on my own!
