Searchable AND Dependent Dropdowns in Excel (No VBA, No Named Range...)

Описание: The solution proposed here is valid for latest versions of Excel.
You can increase your productivity or the user's productivity at work with this type of solutions.

drop-down or validation list using hierarchical dataset via cascading dependent drop down lists

work smart not work hard
recorded in MS Teams, excuse me for my English and the video quality