Forum Discussion
Trying to create a dependent drop down with simple data
Thank you! See the attached version.
Use Formulas > Name Manager to see the names that I defined.
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?
Here is cleansed data
Thank you! See the attached version.
Use Formulas > Name Manager to see the names that I defined.