Create a Dynamic Dropdown List – Google Sheets

Want to learn how to create a dynamic drop down list in Google Sheets? It happens when you click a small drop down arrow in the cell and it shows you a list of choices. Then after the first selection from that drop down list will help filter another drop down list for another set of options to choose from. This is pretty easy to do by involving the named ranges, the data validation feature and the INDIRECT function.

🔔 SUBSCRIBE to my channel ➜ p

🏫 Excel Training ➜ l

📚 Excel Books & Tech Gear ➜ h

⚙️ Tools: Screencasting ➜ 3

⚙️ Tools: Microsoft Office ➜ G

⚙️ Tools: TubeBuddy ➜ 1

📝 This description may contain affiliate links and we’ll receive a small commission if a purchased is made using the links (but at no additional cost to you). It’ll support the channel and so more videos like this can be made. Thanks for your support!

🎁 If you find these videos useful and want to support my channel go to l


You May Also Like