Excel 365 Drop down search function not available

[Sourdough123]

I have 5 machines in my company running office 365 from 1 license and are running updates every week to keep machines in sync. All the machines but one that do not have the search function available in dropdown lists
Any thoughts
Thanks

 

[Akuini]

All the machines but one that do not have the search function available in dropdown lists

Are saying autocomplete functionality in data validation works on one of your machine?
AFAIK, Microsoft has retracted the autocomplete functionality in data validation, hopefully only temporary. Check this discussion:

Speed up data entry and validation with AutoComplete for dropdown lists in Excel for Windows

(Photos courtesy of NASA) Today, we are excited to announce that speeding up data entry and validation with AutoComplete for dropdown lists is now available in..

techcommunity.microsoft.com

In case you're interested, try using "Search_deList_v2.1", it's a free Excel add-in, it works on Excel 2007 or later.
Its function is to speed up the search in the data validation list. In any cell that has data validation (with type List) pressing ALT+RIGHT will open a User Form with a combobox. You can type multiple keywords (separated by a space) in the combobox to search items on the list.

You can find it here (please check post #81):

I created an Excel add-in called “Search deList”, to create searchable data validation

I created an add-in called “Search deList”, and I share it as a freeware. Its function is to speed up searching in data validation list. In any cell that has data validation (with List type) pressing ALT+RIGHT will open a Userform with a combobox. You can type multiple keywords (separated by a...

www.mrexcel.com

 

[Sourdough123]

Are saying autocomplete functionality in data validation works on one of your machine?
AFAIK, Microsoft has retracted the autocomplete functionality in data validation, hopefully only temporary. Check this discussion:

Speed up data entry and validation with AutoComplete for dropdown lists in Excel for Windows

(Photos courtesy of NASA) Today, we are excited to announce that speeding up data entry and validation with AutoComplete for dropdown lists is now available in..

techcommunity.microsoft.com

In case you're interested, try using "Search_deList_v2.1", it's a free Excel add-in, it works on Excel 2007 or later.
Its function is to speed up the search in the data validation list. In any cell that has data validation (with type List) pressing ALT+RIGHT will open a User Form with a combobox. You can type multiple keywords (separated by a space) in the combobox to search items on the list.

You can find it here (please check post #81):

I created an Excel add-in called “Search deList”, to create searchable data validation

I created an add-in called “Search deList”, and I share it as a freeware. Its function is to speed up searching in data validation list. In any cell that has data validation (with List type) pressing ALT+RIGHT will open a Userform with a combobox. You can type multiple keywords (separated by a...

www.mrexcel.com

Thanks