Dynamic Excel Drop Down Lists - PLUS how to get SEARCHABLE Drop Down Lists!

Excel Data Validation Drop Down Lists are great for ensuring data is entered uniformly and is easy to work with. In this video I cover various ways to set up drop down lists so they dynamically update as new data is added to the source list. PLUS how to get searchable drop down lists without upgrading Excel!

0:00 Excel Drop Down Lists aka Data Validation Lists
0:28 Creating Drop Down Lists
3:00 Dynamic Updating of Lists on same sheet
4:15 Dynamic Updating of Lists on different sheet
6:41 Dynamic Array as List source
8:21 Searchable Drop Down Lists

[alwaysonyt]

One the best "dynamic drop-down list" tutorials out there on YouTube, currently. thanks ma'am.

[jonk]

That part of using unique and sort is amazing for those with office 2021or Microsoft 365. I always get something new from your tutorials..big thanks

[mohammedadnan]

lot of thanks for you ! really this is what I was missing to understand especially using the height and width in offset formula . please keep going posting such valuable videos .

[tastebuds]

One of the tutorials on drop down lists. You answered my question about the data source being on a different sheet. Thank you so much.

[ctran]

Wish I found this video sooner! Very clear & concise. Thank you so much. Liked & subscribed

[signalmas]

I found this tutorial very useful and will share with my team. Thank you !

[malikastar]

Thank you a lot, that was really valuable, I like your videos, they are straightforward and detailed

[TVSCDN]

Thanks for your great validation updates 🙏❤️👍😍

[mimicatibayan]

Awesome..
Simple and easy to follow..
Thank you so much..

[darrylmorgan]

Hi Mynda!Super Helpful Tutorial..Thank You :)

[pvrameshbabu]

Thanks video explaining various options for drop down lists nicely.

[iankr]

Mynda - many thanks! Let's hope that MS push out those updates to the wider community as soon as possible. Also, enable you to directly reference a structured Table name directly in the DV List Source dialog. That can't be an oversight - there must be a good reason why that isn't supported?

[davidlinton]

Thanks Mynda! Great update for me on the latest.😁

[jerrymiles]

Outstanding! Best regards from Limón, Costa Rica!

[harryp]

Very timely information! Would you provide a recommendation on setting up something similar to a form for users to query a dataset, using 5 fields, to get to a unique record? I have a dataset of > 800K records that users need to find a unique record based on the 5 fields. I can use Excel 365 or Power BI for this form.

[rodyeltabaa]

Nice video. Also, I have found an efficient and v. simple way to reference to every table in workbook in a drop down list then reference to the table's headers in another drop down list and finally get a unique list of that column in a 3rd dependent drop down list.... and Only using the INDIRECT fuction....
happy to share my findings with you 😊

[strategicentrepreneur]

Really Helpful it became useful to me for Analysing my Personal Budget more convinietly.👍👍😀

[kylejacobs]

I thought I was tripping when it cell reference changed when you had it as an absolute reference when you first selected the data. I use to always use offset to make it dynamic. This is much easier. Always a fan of your work!

[nigelsapalit]

Learn a new thing again.. Thanks for uploads..

[TheDarthpsi]

THis was exactly what I was looking for, thank you.