▶📃 DEPENDENT DROP-DOWN LISTS WITH DATA VALIDATION IN EXCEL (INDIRECT FUNCTION)
Creating dependent dropdown lists has never been easier. In two minutes, I'll explain how simple it is to link two dropdown lists using the INDIRECT function and naming the list rows. We then link them using data validation, and the values that appear in the second list depend on the value selected in the first.
JOIN MY FACEBOOK GROUP: / 3662555313858069
COMPLETE EXCEL COURSE (FREE): • Curso Master de Excel
VISIT MY WEBSITE: https://aprenderexcel.es/
LEARN TO CREATE AN INVOICE WITH EXCEL: • Factura básica realizada con Excel incluye...
LEARN TO MANAGE YOUR WAREHOUSE: • Plantilla de control de stock con función ...
DOWNLOAD THE FREE INVOICE TEMPLATE: • Plantilla de Excel para facturación totalm...
CREATE A DASHBOARD: • El mejor dashboard de ventas con Excel con...
TO DOWNLOAD THE VIDEO FILE, SUBSCRIBE TO MY CHANNEL (CLICK ON THE LINK)
/ @manuelaragonesprofesor
AND DOWNLOAD THE FILE FROM THIS LINK (CLICK ON THE LINK BELOW)
https://aprenderexcel.es/download/573/
MANUEL ARAGONES, COMPUTER SCIENCE TEACHER
KEEP LEARNING WITH ALL THE LESSONS
👉Lesson 1 Basic Concepts: https://bit.ly/2Sta6Pm
👉 Lesson 2 Basic Formulas: https://bit.ly/2SloNnk
👉 Lesson 3 SUMIF: https://bit.ly/2TZRJ4G
👉 Lesson 4 Tips and tricks, and the IF function: https://bit.ly/35Lb5gz
👉 Lesson 5: VLOOKUP: https://bit.ly/3wUeLbR
👉 Lesson 6: Filters, index and MATCH, database functions: https://bit.ly/2SRNxUJ
👉 Lesson 7: Pivot tables: https://bit.ly/3qkG3Wz
👉 Lesson 8: Subtotals, charts, and conditional formatting: https://bit.ly/2TYP8bk
👉 Lesson 9: Goal Seek, Solver, PMT function: https://bit.ly/35PJcnU
👉 Lesson 10: Macros: https://bit.ly/3qna9Zs