Forum Discussion
Multiple dropdowns using shared terms
Hi, I'm trying to create an interview form in Excel with multiple dropdowns. Essentially, if a certain role type is selected, I need the form to bring up a set of questions related to a particula...
To create a dropdown form in Excel that meets your requirements and behaves as desired, you can employ a combination of named ranges and the INDIRECT function for data validation. The goal is to allow users to select a role and a competency, after which a corresponding set of questions is displayed, without displaying the variations of group names for each role.
Thanks - will give that a try!