Searchable Data Validation List

[Excel1991]

Good morning all,

Does anyone know if there is a way to make the data validation lists searchable? I have items in my list that are similar so it would be more efficient if, when I started typing in a search bar, the results would be filtered by my letters.

I understand that you can make a search bar with ranking formulas but I have about 7 data validation lists and would rather not do that process 7 times. Is there an easier way to do this? Thanks!

 

[Rijnsent]

Hi Excel1991,
try something like this: https://www.extendoffice.com/documents/excel/2401-excel-drop-down-list-autocomplete.html#a1
Or an alternative: https://www.ozgrid.com/Excel/autocomplete-validation.htm
Cheers,
Koen