✅Create a DROP-DOWN LIST in EXCEL with DATA that VARY depending on what a cell has
🎯 Learn how to create a drop-down list in Excel that automatically CHANGES based on your selection in another cell—no macros or programming required!
-------------------------------------------------------------
👨🏻💻 👩🏻💻 If you'd like to download the video file to practice, you can download it at the following link:
https://smartprosoluciones.com/crear-...
-------------------------------------------------------------
✍ Would you like to know your current Excel skill level? Take our free test and discover how much you're really getting out of Excel 😏👇:
https://maraton.smartprosoluciones.co...
-------------------------------------------------------------
Did you like it? Support me with a LIKE 👍 or tag someone who might find this tip useful.
You can also stay connected with me on Instagram and Facebook 😁: @SMARTpro Academy
► Instagram: / smartproacademy
► Facebook: / smartproacademy
-----------------------------------------------------------------------
00:00 Introduction
02:14 How to easily create a dropdown list?
04:00 Making a list update automatically
05:49 Creating a name for the list's source range
09:29 Drop-down list with changing data
10:09 Assigning multiple names to multiple ranges
15:07 Applying the INDIRECT function
18:39 Drop-down list with data that changes in two cells
25:13 End