Forum Discussion

Davidm54's avatar
Davidm54
Brass Contributor
Feb 22, 2021
Solved

Setting up Searchable Dropdown list (WITHOUT Filter function)

Hi All,   I'm trying to set up a searchable dropdown list. It'll effectively be for searching for clients by name.    I am trying to avoid using the filter function as not everyone will access th...
excel
Formulas and Functions
office 365
  • Davidm54's avatar
    Davidm54
    Feb 22, 2021

    Davidm54 Well, for the sake of folks searching this. The formulas in the link work. The answer is to not mess up cell references. I had one column doubling up. 

     

    Link in OP is worth saving if you want to do the searchable drop thing.

     

Cangkir's avatar
Cangkir
Brass Contributor
Mar 31, 2022
Another option:
You can try using a free Excel add-in.
Just google "Excel add-in called Search deList".

Resources