How To Search Drop Down Lists In Excel Using The List Search Add-in

Learn how to search drop down lists in Excel with the List Search Add-in. Makes all data validation lists searchable WITHOUT complex formulas or any setup work.

This is a FREE add-in that allows you to quickly type a search for a data validation list in Excel. It also works on columns of data that do NOT contain data validation.

The search works exactly like a Google search, and will filter down the list as you type. It does a partial match search to also suggest results that contain the the search phrase.

There is no built-in way to search a data validation list in Excel, and the List Search Add-in solves this problem by allowing you to search any drop-down validation list in any workbook. There is no setup required. Simply open the add-in from a button on the ribbon and start typing your search.

The add-in is packed with features that make it easy to find the item you are looking for and input the value into the active cell.

List Search is a FREE download from Excel Campus. Please click the link below to go to learn more and download the add-in.

Here is the video of the November 2016 Update for List Search:

Here is a video of the April 2017 Update for List Search:

[richardheathcote]

Wonderful add in - so much easier than ANY other method I've come across. Thank you.

[Bradedgardotcom]

Slick idea Jon. It's definitely a pain point when you are looking at dashboards that are built in Excel. Definitely a useful tool for that!

[zwmnt]

Jon you are a genius an a generous soul. Thank you so much for sharing your hard work! It is very useful.

[siddharthbaori]

May God shower all his blessings on you dear John.

[dingles]

Great add-in, but why doesn't works when the drop list is loaded from INDIRECT function cell? thanks!

[wasimarabic]

Thank you so much for sharing your hard work! It is very useful.

[ParallelIUniverse]

can i run the add in through a macro assigned to a button ?

[tomslazdovskis]

This is perfect! I set up the add in and tried it out in 5 mins.

[Vikas_Bhalekar]

Thanx thanks again sir i am so happy today.. i am lot of video see for searchable drop down list.. thanks i am download this

[kameshsbi]

Such a wonderful add on sir. Thank you very much.

[horizoninc.]

Thank you sir for providing just a useful tool.

[deepakmirchandani]

Resp sir, i have learnt a lot from your valuable videos. thanks. further, in a data validation list if we give the source from name manager and if we type any thing other than the entries of the dropdown list in the dropdown cell, no error message comes. why? secondly if we want to give the source from another sheet to a drop down list, we can't do that. why? pl help



[regaadit]

Amazing Tools! Thank you very much for your job. Subscribed!

[ChristopherAguilan-is]

what version of excel you're using?

[anbakumar]

Hye sir, can I get a guidance video on searching document to view in excel by using drop box list?

[nonameneveraname]

Is there a way to disable the Validation Error? In a regular data validation list I can turn off the error if I type in something that is not actually on the list. This way I can use my list but also type in any other item that may be needed. I've disabled the error that Excel pops up, but the one from the Add-In still comes up.

[digitalinfotreasury]

brilliant solution. exactly what i need. thank you.

[mingmeow]

It really helps, thank you very much.

[rishabhdhiman]

Hello sir,
It's a very good option but how to keep it always in the workbook. If it is possible to keep there it would be a great HELP.

[Anonymous-mzfn]

Hi there can anyone help me... ? I have excel data and have applied filtered to it.. and i want to add information to each item i. the list of filtered data. Now As list is long and I am selecting each item one by one by scrolling down. Is there any way to skip to next item in the list instead of scrolling from mouse as my list is very big and i have to go very down to select next value