Create a drop down list with extra features

[Lun]

Dear All,

I have a list of company names

I wish to create a scroll-able drop down list in excel with one extra function.

I hope it can bring me to the list of customer according to my input of their first alphabet of their name.

For example,

I press on "B" on my keyboard. The drop down list will bring me to the first customer who start with name "B", likes "Big Boys Corporation".

Hope to get some help here. Thank you.

[alansidman]

https://www.contextures.com/xlDataVal01.html