Tag Archives: Dependent Dropdown

Dependent Dropdown menu using OFFSET in #Excel

Posted on December 16, 2023 by MF

Quite a long time ago, I wrote about two different approaches of preparing dependent dropdown menu in Excel. The first approach was for non Excel365 users, while the second approach was for Excel365 users. You may refer to the post … Continue reading →

Rate this:

Posted in Formula | Tagged , , , , , , , | Leave a comment

[Video] How to create a dependent dropdown list in #Excel

Posted on July 1, 2021 by MF

This is the follow up post from my previous post – How to create a dependent dropdown list in #Excel. As mentioned, it could be easier to illustrate the concept using a video, especially for the use of Dynamic Arrays. Here … Continue reading →

Rate this:

Posted in Excel in Action | Tagged , , , , , | Leave a comment

How to create a dependent dropdown list in #Excel

Posted on June 27, 2021 by MF

…with and without Dynamic Arrays (which is available to Microsoft 365 users only) Got a question from a friend recently: Is it possible to show a different set of questions in a dropdown list depending on the answer input from … Continue reading →

Rate this:

Posted in Excel in Action | Tagged , , , | 2 Comments

Dynamic Dependent Dropdown by Data Validation

Posted on March 15, 2014 by MF

So many D. 😀 This is a continuation of the previous post: Not all teachers are eligible to all classes.  e.g. only Iris and David are eligible to deliver Class F, would it be feasible to have only Iris and … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | Leave a comment