How to create searchable drop down list for multiple cells in excel

[phongky2013]

How to create searchable drop down list for multiple cell in excel.
I need to import the data sheet in excel, I created a drop-down list with datavalidation but the listbox is too long. Please help me to create searchable drop down list in excel but for multiple cells. Thanks

 

[phongky2013]

Please help me, I need urgent. Thanks a lot!

 

[huyle2103]

You can use functions: offset, match, countif, counta when create define name (name range). Watch a video reference: https://www.youtube.com/watch?v=Rpdzn906UBA

 

[phongky2013]

Excellent, just what I needed. Thank you very much, you are my savior

 

[huyle2103]

Excellent, just what I needed. Thank you very much, you are my savior

I'm happy that the video can help you

 

[phongky2013]

I'm happy that the video can help you

Your method are search from the first character, but I want to improve more than is any how to search from any element position in the list. Thank you!