In a dropdown list I would like to have users type in the cell to initiate the search

Copper Contributor
Spoiler
I have created dropdown lists in my worksheet that look up values in a worksheet within the same workbook.  The list is very long and I would like to make it easier for my users to find the items they are looking for.  Currently there is no choice but to scroll through the dropdown list.  Ideally they could start typing the value they are searching for and the lookup would use that to find those items in the list.  I could not find this option in the data validation menu.  Is there a way to make this work?
1 Reply

Hi @cperezimpulse 

 

There's no simple way to do this

 

MVP Mynda Treacy has a cool hack using a Pivot Table Filter box here

https://www.youtube.com/watch?v=NqvB-DqIuP4

 

and MVP Leila Gharani has one here if you have the new FILTER function in Office 365 

https://youtu.be/Z-h2UER3b_0

 

 

Hope that helps

 

Wyn

MVP

Australia UTC+ 8

 

If this answer was the best response please click the button

I also happily accept likes