How To Create A Searchable Dropdown List In Excel

Learn how to create a searchable dropdown list using data validation ! 👇

Check out my full courses and ebooks here

DOWNLOAD the example workbook here

SUBSCRIBE & get my 3 FREE eBooks

CONNECT with me on social

Thanks for all your support!

[HowToExcelBlog]

Check out my full courses and ebooks here

[colinhuntley]

hi john, shameful to say that i just discovered your videos, but i am glad that i did! this tutorial in particular has made my excel experience even more fun... thanks a bunch! when i clicked on the :"DOWNLOAD the example workbook here" link, i was able to see many great example files to download, but this one was nowhere to be seen! could you please help me with this? regards, colin

[OzduSoleilDATA]

Great solution. I've needed this before and this solution is better than the one I came up with. 🏆

[anthonywilkerson]

In the Define Name, what is the formula in the Refers to Box? On my screen it's blurred out. Best solution I've seen so far; short and simple.

[Luciano_mp]

It will be of great help, very useful. This worksheet you have not available?. Thank you.

[andybongkimpoh]

Hi Thanks for the guide, how to make the excel searchable dropdown for multiple worksheet ? Thanks

[sameh]

If you make a cell for search other than the data validation cell you can use it for a whole column

[rvrcr]

Hi I followed step by step but and last step after "Define name" when I open "Name Manager" and see the referencing cells it takes me to Column V Row 3?

[anandakrishnans]

How to put drop down on the other cells of column C

[vncmra]

Thanks, this is perfect but I have a problem. I have a column full of validation data, this works if you only have one. How could I do? Maybe if you made a video .... Thanks again