Forum Discussion
Solved
Trying to create a dependent drop down with simple data
I need to create 2 drop downs. The first one I've created already and it works, but the second drop down is dependent on what the first says. Here is the data: I have used =INDIRECT("Category") ...
Thank you! See the attached version.
Use Formulas > Name Manager to see the names that I defined.
Hi Hans,
Confused by this as the data validation rule is not referencing the named ranges at all....does it need to?
I get an error when using the formula (the first drop down is F2 on my sheet)
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Here is cleansed data
Thank you! See the attached version.
Use Formulas > Name Manager to see the names that I defined.
Aaah thank you Hans. Very kind and helpful.