Searchable drop-down cell in Excel

[TopLearner]

Good evening all,

Let´s say that I have the column A with all my customers´ names.
Then in cell B1 I want to have a drop-down list so I can click on the arrow and select the customer I want.

Is it possible that by typing the first letter of the customer name the drop-down shows all the customers whose names begins with such letter I type in?

Thanks
Sanchez

 

[Peter_SSs]

See if either of these help.
Macro to create searchable data validation+combobox
Show Excel Data Validation Drop Down Items in Combo Box