Search option in the given cell

[harinsh]

Hi Team,

Can I create the similar like google search in the excel when I define range it should show the names which I type. For example, in my list if I have "London" then the moment I type "L" it should show list of words start from "L". Later I should use this as reference for my further activity.

Can anyone help me on this? How to create this option in the excel cell ? Ok if you can give me vba code so, that I will work around for creating macro...

Thanks,

 

[istiasztalos]

I think this is what you are looking for:

https://www.extendoffice.com/documents/excel/2401-excel-drop-down-list-autocomplete.html