Automatische Texterkennung mit EXCEL Dropdown

JuliusDaredevil  Yes there are a number of tutorials on how to create this functionality.  Basically you use a helper column so the data validation is based on this helper column, which is a filtered list based on what you type in that cell.

So if column A has the list and cell C1 has the dropdown, then in cell B1 enter something like:

=SORT(FILTER(A:A,LEFT(A:A,LEN(C1))=C1))

then C1 data validation list would be based on column B so after you type your first letter or 2 then hit the dropdown you only see the entries in the list that match.

NOTE: I have seen some reports that Mac Excel doesn't update when you hit the dropdown arrow so they have to hit enter THEN dropdown button.

Here is a link with a tutorial. This tutorial narrows the list based on a more general search (the typed info can appear anywhere in the list item instead of only starting as you requested) but the technique is well explained:

https://www.xelplus.com/searchable-drop-down-list/