Forum Discussion

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
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.

legitautomotive

Copper Contributor

Sep 24, 2021

Hi I am working on the same requirement, implemented all the formulas mentioned, everything was smooth till the end and all worked fine but at the end I faced a problem while creating a drop down list, i see a pop up message saying "The source currently evaluates to an error" and drop down list is not coming please suggest. the solution.
thanks a ton in advance for the suggestions

Juliano-Petrukio

Bronze Contributor

Sep 24, 2021

legitautomotive

I suggest you open a new forum thread.

By the way, there are a lot of different solutions regarding it as well.

Recently I assisted an user with this solution

Take a look there.