Forum Discussion
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") within the Source field of a Data Validation list for the first drop down, which works. But what do I use for the dependent drop down?
Thank you! See the attached version.
Use Formulas > Name Manager to see the names that I defined.
6 Replies
Select Stage 1 Warning to Self Certification and name this range Attendance.
Select Medical/Health Issues to the last subcategory for Authorised absence and name it Authorised_absence (note that the space has been replaced with an underscore; a range name cannot contain spaces).
And so on for other categories.
Let's say you have a category drop-down in for example C2, and you want a subcategory drop-down in D2.
The formula for the data validation rule in D2 is
=INDIRECT(SUBSTITUTE(C2, " ", "_"))
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?
