How to select a item by typing a letter or word in excel dropdown

Suppose in drop down list there are 500 items are there and I want to select one item and I know the spelling of the word also then how can I select by typing the word. For example in Bank sites if you want to choose a branch then if you will type few letters of the place name then it is coming the suggested words. In the same manner I want so is there any option to do it.