Dynamic dependent data validation lists are easy with dynamic array formulas, but in this video I show you both with and without dynamic arrays. Download the Excel file here: https://www.myonlinetraininghub.com/dynamic-dependent-data-validation

To dynamically expand the regions for more countries, copy the FILTER function across multiple columns and use the "not found" argument in FILTER to return an empty result with two quotes, for example:
=SORT(FILTER(TblRegions[Region],TblRegions[Country]=H4,/"/"))

Then change XLOOKUP to include additional columns. For example, if your FILTER formulas are in columns H:P, your XLOOKUP would be:
=XLOOKUP($B5,$H$4:$P$4,$H$5:$P$5)#

0:26 Dependent data validation without dynamic arrays
1:28 Setting up data validation lists
1:55 Setting up dependent data validation lists with INDIRECT
3:12 Dependent data validation with dynamic arrays
3:25 Unique list for primary data validation list
3:56 Secondary lists for dependent data validation lists
5:20 Setting up dependent data validation lists with XLOOKUP

Check out my comprehensive courses: https://www.myonlinetraininghub.com/

Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/

Please take the opportunity to connect with your friends and family and share this video with them if you find it useful.