Searchable and Dependent Drop-down list in Microsoft Excel

#DropDownlist #Office365
Hello Friends,

In this video, you will learn how to create Searchable and Dependent Drop-down list in Microsoft Excel. We have used Dynamic Array function of office 365 to create the drop-down list.

Download the practice file from the below link:

Download the Free Project Management Dashboard


See our Power BI Dashboard videos:


Learn and download our interactive Excel dashboards free of cost-
Download the Calendar Control in VBA from below link

Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

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

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Pinterest:

LinkedIn:

Instagram:

Visit our Amazon Store

[alexrosen]

The best tutorial on this topic that I have found. Extremely insightful and useful, especially if you work with these kind of things 👌🙏👌

[chrispinodinga]

This is one of the best tutorials I have watched so far. Thanks for sharing Sir.

[nsanch]

Thank you for the great video on drop drowns with new 365 features. I learn so much from you PK.

[KingTechCodingClinic]

I'm grateful for having you as my mentor. your channel has really helped me grow my channel. Thank you very much PK. You are indeed an Excel Expert

[dariuszspiewak]

Hi there. The raw data should be put in an Excel table (CTRL+T). Then you would have a much easier time creating references in your formulas and also you wouldn't have to worry about updating the entries when new rows are added to the table. That would be automatic. And you would be able to also type below the table(s). As it stands right now you can't do this because you've had to pass almost the whole column to your formulas. Please, when you can use Excel tables. They are much safer than just plain ranges. On top of that, I'd suggest naming ranges as well. This will then enable you to get rid of the ugly long references.

[iftekharraju]

You are genius.. I learned lot from you..Thanks a lot sir.

[NooDPee]

It's very useful and easy to understand. Thank you so much.

[pushpajchougule]

very great video. can this be done in other excel versions?

[humayoonshah]

Very nice and helpful video, thank you very much

[VINAYYADAV-mt]

Hi pk, Pk utility tools, there have been you mentioned Searchable Dorp down list, it's not working, kindly check

[M_Heihger]

Thank you so much
Very nice tutor video

[qistiq]

Hi, may I know if the searchable feature is limited to Excel on Windows? I can't seem to get that to work on my Mac. Thank you!

[excelemployeeleavetracker]

Great video...would it be possible to make the database a table and /or name range each column then you would not need to highlight all the cells in the columns? Thanks

[sprucesteven]

Thanks. Can I have the formulas you used the filter and unique for all the steps. I find it difficult to see the formula used.

[abdullahquhtani]

Can that be applied to make multiple dependent drop down list for example 5 or 6 levels?’

[dareoluwakemi]

Good evening Pryiendra Kumar

Which formulas can we use in place of UNIQUE, FILTER AND SORT in earlier versions of Microsoft Excel (2016 to be precise)

[Yorumcu]

Great video Thank you.
Coud you make a video about stock control in same codes.I mean Have products have some input materials buying from firms and some selling records to another firms .We need check stocks (total inputs in a line and total sells in a line and stock quantity in our stok for same material
Thank you

[shinminah_]

hii, could make formula for multiple Dependent Drop-Down Lists in Excel (on Every Row) ?

[satyenshukla]

Good one. But I'm not getting searchable function Pl help

[mirceabarb]

What is the code for the task from 01.09 to 01.14? What order should be given? ..."tar"?? I don't understand what needs to be done to make the selection appear after the letter.