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.

Richard2100

Copper Contributor

Nov 03, 2022

Does anyone know how to make this work for multiple rows?

Basically so that you can have a searchable list of drop downs for an entire column of cells rathe than just one? I've tried versions using Sort and Filter but my client has an older version of Excel which doesn't support these functions!

Thanks