Published On Apr 8, 2020
This Excel searchable drop down list is dead easy, requiring no VBA/macros and no formulas! In this video I use it to build an interactive chart linked to the drop down list.
🔻 DOWNLOAD EXCEL FILE HERE: https://www.myonlinetraininghub.com/s...
🎓 LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: / myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/e...
⏲ TIMESTAMPS
0:00 Introduction
0:21 Searchable Drop Down List Chart Example
1:07 Creating a Searchable Drop Down List
2:03 Formatting your Searchable Drop Down List
2:36 Referencing in a Formula
7:23 Linking Searchable Drop Down List to a Chart
9:46 Demo Finished Result
10:43 Shortcomings