Excel Tip: Searchable drop down list in Excel

Hello Friends,

In this video you will learn how to create searchable drop down list in Excel.

Please download this excel file from below given link:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Facebook:

Telegram:

Twitter:

Pinterest:

Send me your queries on telegram:
@PKanExcelExpert

[siddharthmehta]

amazing solution bhai.. just one question, should i save the helper rows or can i get rid of them ?? also can i move this search box to another tab ?

[tomasmaropa]

What a clear explanation brother. I have a question, I have a workbook with 3 sheets, ie an Invoice, Cliente database and Product database. I have created a searchable multi cell dropdown box list and a single dropdown list for cliente. If I use a indirect(cell("address")) function, the dropdown lists conflict. How mai I avoid this?

[TheRamanacv]

very brilliant and helpful idea brother

[Jon_from_LI]

Quick question, PK. I was able to use your method for my own list; it works fine on the page with the array, but how would I be able to carry that formula for the searchable drop-downs down a column on another page?

[AbhishekPandey-jdgh]

Excellent explanation... but I have a question, can u tell me how to show "No Record Found" in the dropdown list when any keyword doesn't match with given data?

[SimohmedRaiss]

Thank you so much for this useful and helpful method. It's very well explained.

[fredericksantonia]

thank you very much its really helpful

[ferough]

Thank you so much for this video. What if I have multiple dropdown menus on a sheet? Once the index and frequency are set to 0, I can't use the next drop-down menu to search. Can you help me please?

[amirsazo]

Very good idea useful and simple, Thank you man

[pauldhinakaran]

Thanks nice one question .I need to fix searchable drop down list for particular colum ex A:1 to A:50 .how can I see this forumala .you have demonstrated for one cell my case is conescutive colum.pls explain

[tammylang]

I could kiss you. This was so easy to learn and implement and it was exactly what I was looking for!!! Thank you so much!!

[PrasannaA]

This is a excellent work ... it realy worked for me... hat off sir

[PrasannaA]

ho do we get the formula wok for multiple cells in a column - it works only for one cell in a column

[aeronjackson]

Great Video!! Awesome Job. It seems to not work in Office 365. This is the second video that I have followed and it still didn't work. I watched the video 100 times and made everything exact... It does not search. It always shows the same complete list. Can I please get some help? Everything worked until I put it in the drop down. Thanks

[srinivasbabunandipa]

Hi PK, I have problem while I'm searching the record .. the first record is missing and showing rest all records. for example if I search ind it is showing only Indonesia but not showing India

[markusprea]

Very useful, it's an amazing work.

[jayapavithra]

Hello pk! It would be much helpful if you can upload a video for dropdown calendar.

[chonghs]

Very good, nice explanation, this has really helped a lot. Thank you!

[faisalmuhammadkhan]

If i copy the cell G4 and paste on G5 then result is not right, because in search I freeze G4. So If i make a range of drop down cells then what should I do.

[jbgonzalez]

Thanks for sharing this great trick.

I wonder if you can use this dropdown list in a excel table.