drop down list using data validation

[lucky22]

Hi,

I have read lots of threads/posts but I am not getting anywhere.
I have a list on one worksheet and I use a dropdown list from Data Validation to select the name required.
my list is so long that I would like to be able to type a letter or two to access to the name quicker instead of scrolling down.
I copied a formula that worked for someone else that put this formula in the data validation (IF(I36<>"",OFFSET(Player,MATCH(I36&"*",Player,0)-1,,SUMPRODUCT((MID(Player,1,LEN(I36))=TEXT(I36,"0"))*1)),Player))
I do not wish to use VBA is possible.

thank you in advance

[6StringJazzer]

Instead of data validation you can use an ActiveX combobox. That will give you the first matching choice as you type. However, I'm not sure how to tie your formula to the combobox contents without knowing more about what is in I36 and what is Player. You may be able to create a named formula using your formula, and then use that name in the ListFillRange property of the combobox.

Do you just have one dropdown, or many?