Forum Discussion
Third Dependent List Not Working
Hi there. I'm trying to create three dependent drop down lists for a database I'm building but can't seem to get it to work. The three fields are: Department, Division, and Program. The Division options will be based on what Department is selected, and the Program options will be based on the Division. The Division and Program options are all unique, so I can't just use a standard list. The Department and Division lists are working, I just can't get the Program list to correspond the the Division.
I thought I could name a Program list as one of the Division Options using Name Manager, but the Division names are more than one word.
I've included a couple of screenshots. Any help would be greatly appreciated!
1 Reply
Find the attached file for a solution to the third dependent list.
I basically used "list" on "data validation" for all the three lists after setting up a different sheet with the required data (screenshot of the data sheet given below for reference).
- The data validation for (Col B) Dept. is the list of yellow highlighted cells from the 1st table in data sheet.
- The data validation for (Col C) Division picks up the list of divisions for that respective department as given in the blue section of table 1 in the data sheet using offset and match formulas
- The data validation for (Col D) Program required the second table that has the list of programs for each "Department" "-" (hyphen) "Division". it uses the same data validation formula as the second list.
You can hide the data sheet incase you don't need to make too many changes.
