How to make dropdown searchable

[chris torres]

I have all the information on my first worksheet for names in the dropdown items.

From there I named my columns for dropdowns to use for data validation.

My next worksheet it where the drop downs are for my users. I have about 6-7 columns on that sheet that have 200 rows of dropdowns.

I would like some information on how to have my users type in the cell where there is a drop down, and have it search my dropdown list.
Since the list are massive.

Basically if they type something similar to what is in the list it gives the users the closest possible options.

Again I need to do this for about 6-7 columns that have about 200 rows.

any help please

-Chris-

 

[chris torres]

Re: searchable dropdowns

some please help

 

[NoSparks]

Re: searchable dropdowns

Can you explain what you mean by "make each of the cells with dropdowns searchable for the user" ?
How would it be known what to search for ?

 

[Peter_SSs]

I'm not sure this is exactly what you want, but see if it helps at all.
http://www.contextures.com/xlDataVal10.html

 

[chris torres]

ok so I followed this video it worked perfectly for what I am trying to do
https://www.youtube.com/watch?v=vkPoViUhkxU

.... except for it only does it for the first cell I apply the data validation list to. How do I get it to apply the same data validation for the entire coulumn