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?