Searchable drop down list

Hi,
i want to make two or more seachable drop down list.
i can find a excel file from youtube youtube com watch?v=8gqodEiDoJ8 (as attached)
this is a big help already.

this file provides one seachable drop down list. But can i add more seachable drop down list up to 10 seachable drop down list?
10 list can work on the same worksheet

My diffculty, it seems i can put more formula for more down down list but seem that i am not correct in data vaiidation part.

I know this thread is in Formula section, but maybe you’re interested in VBA method to solve your problem.
As an alternative to searchable data validation, I created a searchable combobox that can appear and hide automatically when you enter a cell in a certain range, it uses VBA not formula.
Even if the data is not sorted and has duplicate items & blanks, the list in the combobox will be unique, sorted & no blank.
If your data is large enough, say hundreds or thousands of rows, it might suit you..

It’s pretty easy to set up. Let me know if you’re interested, I can help you set it up.
Here’s an example:

Hi Glenn Kennedy and Akuini
both of your file works. In these two days i spend times to verify where my mistake is.

i finally complete a 20 searchable drop down list as attached. Thanks a lot for your help.