Autocomplete dropdown

As far as I can tell Excel has no native capability to make a dropdown that dynamically narrows the list as you type. This would be very useful for data validation dropdowns with very long lists. Doe...