Looking for a way to use a drop down menu to change cell references in a formula

[joana_ads]

I created a drop down list in excel. But now I want to type the first letter and have instant access to the item on the list instead of having to open the drop-down​ menu and choose from a big list. Can someone help me?