Data Validation drop down list autocomplete

[odartey]

Hi all
I have a lengthy list of which I want to just type the first two letters and a suggestion will pop up so I pick from. Data validation does not allow for that, since you will have to scroll through till you find want you looking for.
Can I get any help?
Thank you

 

[Chihiro]

See Nebu's post in below thread (his file has searchable drop-down in Item Description).

http://forum.chandoo.org/threads/multiple-dropdown-lists-with-same-data.25687/#post-153717

If this isn't what you are looking for... there are several other methods.
Such as one using Combobox with helper formula etc.
http://trumpexcel.com/2013/10/excel-drop-down-list-with-search-suggestions/