I made an attempt to use this youtube video ( https://www.youtube.com/watch?v=pjLAnpBM9dk ) 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.
| region | state | code | name | dateofvisit |
| south_west | ogun | OG136210 | Banjo Philips | 9/10/2022 |
| north_central | abuja_fct | OG135925 | Damar Oluwole | 9/11/2022 |
| north_west | Kaduna | KD023000 | Abioye Ishaya | 9/12/2022 |
| north_east | borno | BO135028 | Yahaya Katikua | 9/13/2022 |
| north_east | borno | BO216032 | Prince Glory | 9/14/2022 |
| north_central | abuja_fct | FC045765 | Caro Usma | 9/15/2022 |
| north_central | abuja_fct | FC022996 | Simion Lilo | 9/16/2022 |
| south_west | ogun | OG136210 | Pataya Ilori | 9/17/2022 |
| south_west | ogun | OG135925 | Gamisin Margret | 9/10/2022 |
| south_west | oyo | OY146252 | Talatu Friday | 9/11/2022 |
| south_west | oyo | OY256238 | Maruf Toluwani | 9/12/2022 |
| south_west | oyo | OY265847 | Abass Pasuma | 9/13/2022 |
| south_south | Akwa_ibom | AK094925 | Risikat Akpan | 9/22/2022 |
| south_south | Bayelsa | BA134912 | James Buga | 9/23/2022 |
| south_east | Imo | IM134916 | Boris Alinco | 9/24/2022 |
| south_east | Anambra | AN134928 | Sani Jango | 9/25/2022 |
Can you please upload a sample of your file so we don't have to recreate it in Excel? Thank you.
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:
=XLOOKUP(A24,$J:$J,$K:$K)#
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.
