Nov 06 2020 01:09 PM
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?
Nov 06 2020 01:25 PM
See Create Dependent Drop Down Lists for clear instructions, with a video, a downloadable sample workbook and links to more advanced examples.
Nov 12 2020 12:03 PM
@Hans Vogelaar thank you, this was very straightforward and much easier than what I was trying on my own!