Excel: Create dependent lists that update automatically 🔁
We'll see how to create dependent drop-down lists in Excel.
Drop-down lists are considered dependent when the selection in the first list affects the available options in the second list.
This gives us greater control over the user's choices, as there will always be consistency in the entered data.
We'll achieve this by assigning names and using the INDIRECT function. The INDIRECT function will retrieve the range of cells whose name matches the value selected in the first drop-down list.
If we want to add new data to the drop-down lists, we must be careful to maintain the correct references in each of the named ranges. ---------------------------------------------------------------------------
Link to the exercise file:
✔️ https://tutorialexcel.com/desc-0013
---------------------------------------------------------------------------
You might also be interested in:
🎯 Creating a drop-down list • ¿Quieres datos perfectos en Excel? Aprende...
🎯 Searching by text string • Búsqueda dinámica en Excel: Filtra mientra...
🎯 All about data validation • Todo acerca la VALIDACIÓN DE DATOS ✅ ⛔️
---------------------------------------------------------------------------
🔴 Don't forget to subscribe to the channel to stay up to date with all the latest news:
https://www.youtube.com/c/tutorialexc...
🎬 Watch the latest videos: / tutorialexcelcom
----------------------------------------------------------------------------
📄 Article on the website:
https://tutorialexcel.com/crear-lista...
----------------------------------------------------------------------------
Follow me on:
🌎 WEB: https://tutorialexcel.com
👥 Facebook: / tutorialexcelcom
📱 TikTok: / tutorialexcel
----------------------------------------------------------------------------
Thanks for watching the video and subscribing to the channel 😃 Also, turn on notifications 🔔
#tutorialexcel #excelfunctions #exceltricks