Create a Searchable Drop Down List in Excel

A Drop Down List is extremely useful in Excel. However, If we have hundreds of values it becomes difficult to find the specific value we are looking for. In this tutorial you'll learn how to shrink your list to fewer options by typing few characters and your drop down list will show only options relevant to what you typed.
You can download the exercise file by clicking on the link:
or
Don't forget to subscribe to be notified when new videos are released.

[skthalange]

mind boggling how something so seemingly simple is really challenging to solve, but done and explained in a way that make it possible for a non-expert to try it

[davidw]

i have watched other videos from other "Experts", I must say, you are the best at this. Very easy to understand, you show the steps that can actually are readable. Great video. Thank you so much. David

[godlytjoseph]

Explanation on point. Cant get better than this

[rangasyapa]

This is the best explanation that I ever sow. Really attractive the way u doing it. Thanks a lot. Good luck...!

[reng]

Thanks as always for your great contribution for the excel community! regards from Uruguay Amigo!!!

[thefencetheend]

I find your explanations amazingly neat. Easy to understand for a dummy like me! Keep the great work up.

[excellearn]

Just what ive been looking for! Thanks for this. Clearly explained. Amazing presentation .

[nelson_k_d]

You are Amazing, I checked lot of videos on searchable drop down in excel.
Yours is the best, I must admit.
Keep up the good work.
I'm using your method in my office work.
A very big THANK YOU!!!.

[mikevanwieringen]

Very well explained tutorial..I like the fact you broke it down into little steps which were easy to follow along...Well done and instantly subscribed

[reservationazalea]

sharing your knowledge with us is highly appreciated. keep up the excellent teaching method...

[vadirajasharma]

So useful and explained in such an easy way. Sir Thank you so much. I am a fan of you. I have seen several videos on this topic. Yours is superb.

[wojciechrybak]

I didn't know that the functions Rows and Max can be used in that way. It is amaizing. Your explanaition is easy and clear. I'm sure to use this drop down list in my Excel files. Thank you for the video.

[BalakrishnanNair]

Very well explained sir. Quite helpful shortcuts also. Appreciated

[gopalakrishnarao]

Excellent. Well explained. Thanks a lot. Expecting some more from you.

[udayanarayanajaladi]

Fantastic! Very clear and easy to follow

[LotfyKozman]

Thanks so much for your great efforts, it's very helpful video.

[ronaldofrotta]

Your videos are very didatic! Great job!

[kingfsx]

Thank you for sharing this! It helps a lot! God bless

[evelinreforma]

thanks sir jan.. naa jud ko natun an.. review lang tomorrow.. God bless..

[k.b.jayakumar]

Excellent tutorial, thank you very much indeed. it would be great if you could show an example of INDIRECT(CELL("ADDRESS")) to be used in a searchable drop down list!