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 opti...
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.