August 22, 2022
I made an attempt to use this youtube video () to do multiple dependent drop down list but had some errors linking the third level.
Here is the sample data (below). I want state to depend on region, code to depend on state, name to depend on code and dateofvisit to depend on name.
Kindly provide support.
February 13, 2021
December 7, 2016
You can also read the blog article on this topic.
January 31, 2022
Assuming that you are trying this on Excel365, I believe you need to create separate areas that contain the pairs of data validation lists, as demonstrated in the attached file. Though, I chose to transpose the dependent lists and have them spill horizontally as it fitted my example better. You'll see that the relevant lists (spilled arrays) are contained in columns J and K.
The data validation (DV) formula for "state" is:
and could be dragged across to create the DV formulas for "code", "name" and "date" without having to key them in the DV list box.
See if this works for you.