I am looking for a searchable dropdown list like this https://www.extendoffice.com/documents/excel/2439-excel-drop-down-list-search.html 
but that functions like this autocomplete one https://www.extendoffice.com/documents/excel/2401-excel-drop-down-list-autocomplete.html
also would like it to be dynamic.
Maybe I am asking too much, any help would be appreciated.