Hi guys, Welcome to the Advanced Video Search Engine, and you are watching How to Create a Dependent Drop Down Lists in Excel (with OFFSET, CHOOSE, INDEX & INDIRECT). That video is uploaded by Leila Gharani at 2017-03-23T06:58:46-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [CIJbcBBH88M]
| Name | How to Create a Dependent Drop Down Lists in Excel (with OFFSET, CHOOSE, INDEX & INDIRECT) |
| Video Uploader | Video From Leila Gharani |
| Upload Date | This Video Uploaded At 23-03-2017 13:58:46 |
| Video Discription | Join 400,000+ professionals in our courses here ๐ https://link.xelplus.com/yt-d-all-courses Learn how to create conditional drop-down Excel Validation lists using the INDEX function, OFFSET, CHOOSE and INDIRECT Functions. One aim, many ways to get there. Which one do you like? โฌ๏ธ Download the free workbook here: https://pages.xelplus.com/dependent-dropdown-file ๐ Key Highlights: - Index Function: Discover alternate uses of the Index function beyond its typical pairing with Match, including creating conditional lists and drop-downs. - Offset Function: Learn how the Offset function can be a bit tricky due to its numerous arguments but very useful in creating dynamic lists and conditional drop-downs. - Choose Function: Understand how the Choose function, akin to a condensed version of an "if" statement, can be effectively used in specific list scenarios. - Indirect Function: Explore the Indirect function's unique approach to creating dynamic drop-down lists, especially useful when drop-down names match range names. ๐ Practical Applications: - Create lists that update based on another selection. - Construct drop-down menus that are conditionally formatted. - Learn to adjust for volatile functions like Offset and Indirect in large spreadsheets. Complete Excel Dashboard course: https://courses.xelplus.com/p/professional-excel-dashboards How to create a dependent drop-down when first list contains text with multiple words? Check out this video: https://youtu.be/w7cHgsFirLk Link to Drop-down lists using INDEX and area numbers: https://youtu.be/8hAT18U8qWs Link to Excel OFFSET video - Learn the basics of the OFFSET formula: https://youtu.be/RPTQjbk2qy4 Lecture summary: In this video, I'll show you how you can use the OFFSET formula, CHOOSE formula and INDIRECT function to create drop-down lists that are dependent on another drop down list. โ My Online Excel Courses โบ https://www.xelplus.com/courses/ โก๏ธ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join ๐โ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ ๐ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ ๐ฅ RESOURCES I recommend: https://www.xelplus.com/resources/ ๐ฉLetโs connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/xelplus Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #excel CIJbcBBH88M |
| Category | Education |
| Tags | Excel drop down list based on criteria | dynamic excel lists | dependent drop down lists | conditional drop down lists | data validation | index with refrences | dropdown excel | offset | index formula | data validation with formula | index area numbers | name manager | choose function | indirect function | Excel Tips | Excel Tips and Tricks | Advanced Excel | Excel Advanced formulas | Improve Excel skills | Leila Gharani | Excel online tutorial | Excel | XelplusVis | excel 2016 |
