Create a Searchable Drop Down List Just Like Google - Excel Trick

Create a searchable drop down list in Excel just like Google. This trick is fantastic for large lists. Giving the functionality to search within a list goes beyond a standard drop down list.

This video tutorial will show you how to create a combo box control on a spreadsheet and then use formulas to create a dynamic searchable drop down list.

This list would look awesome on your Excel dashboards and reports.

The video covers multiple Excel formulas and functions including INDEX, COUNTIFS and ROWS. It then uses a simple line of VBA code for the drop down combo box.

Subscribe to this channel to see more awesome Excel tips.

Find more great free tutorials at;

Connect with us!

[RedFiveGamers]

I found the this tutorial extremely helpful thank you! I did have some trouble with the dynamic range for the dropdown list as it would randomly repeat items and have empty spaces. I resolved this by just having the full range available, the empty spaces below were no trouble and it had the added benefit of the full list being available when the combobox is empty!
Cheers.

[Saur]

This is ridiculously useful, thank you!

[wayneedmondson]

Hi Alan.. another great trick and video. For practice, I grabbed a list of US presidents from the Internet and used that as my list of names. Your instructions and formulas were clear and easy to follow. When competed, I added ComboBox1.Value = "" to the double click event of the combo box. So, I can double click the drop down box field to clear my previous entry and start over with a new search. I investigated the possibility of having the scroll wheel of the mouse scroll through the drop down list. I guess there are some complicated ways of getting that to work.. probably not worth the trouble. Thanks again for this great instruction and tutorial. I'll definitely add this to my bag of tricks. Thumbs up!

[asim]

A pure sweat saver. Just Excellent. You just gifted me "Peace" in my work by this tutorial

[venkatalokeswararao]

This is what I am searching for a long time and Thank you very much for your excellent support. ThanQ

[kenk]

A few years on since this video, still extremely useful! Thanks for this! I've always been looking for something like this with minimal VBA, if not none, as possible.

[joem]

Wow what a great video. I had a little trouble understanding the countif function use on the returned list of names to produce the dynamic range. So what i did was use the count function on the column that returned the numbers. It also works.

[aimendondo]

Amazing video tutorial. Please keep adding more excel challenging videos like this as you’re professionally changing people lives on here. Thanks a lot!!

[kevinkirkwood]

Wonderful video. Thanks so much for sharing!! This is incredibly helpful for my application. You did a great job walking the user through the setup process step by step.

[sefatergbashi]

Extremely useful and absolutely amazing. Many many thanks Computergaga, you've just saved a life!

[ForwardBackxHP]

This is brilliant, picked up a lot of handy tips and tricks. There's a couple of comments mentioning the issue where the list is dynamically updating in the combobox, however the list rows are not. It shows the number of list rows based on the count at the time the name range is defined (in your video it's 9). Something that seems to be functioning for me: In VBA where the ComboBox1.DropDown was added when the combobox changes, add in an additional line to dynamically update the ListFillRange also. For your spreadsheet the code would be:
ComboBox1.ListFillRange = "D2:D" & Drop Down").Range("D2:D88"), "?*")

[JosephGabriel]

BRILLIANT! This is just what I needed. Thank you so much!

[MrLADC]

Great tutorial! Very informative and easy to follow. I now know how to repeat this as well as explain the steps taken to get here. Thanks!!

[russromine]

I found this incredibly informative. Really great work!

[DarcyWhyte]

Wow that's a very nice result. I'm gonna have to try that. I think I'd like to make one that works for a whole column.

[entertainmentgalaxy]

wow.brilliant. beautiful video. worth to watch every second of this video. GBU.. thanks for sharing

[ivornworrell]

*Brilliantly explained.I have learnt a lot from this youtube tutorial, thank you.*

[jakesnake]

Great video! Is there a way to create multiple drop down search boxes in one excel workbook page that are independent from each other but still pull from the same lists?

[joshuamanampiu]

It has taken me about 3 days to finally figure this out! But it is amazing. Fantastic Job!

[cyrilbaddegama]

Thanks a lot, I did follow your instructions in the web you have given also use some other tutorials when I get struck, now it's working perfectly. Thanks again for your great support extended.