Forum Discussion

rbalza's avatar
rbalza
Brass Contributor
Nov 14, 2021

Cascading Dropdown

Hi everyone, can't even know how to start. Basically, I wanted to have cascading dropdowns on a tabular form. I have two sheets one is the lookup which is where the data will be coming from and one is the form from where the data should be displayed as a dropdown. The sample file is attached. Thanks in advance 🙂

excel
Formulas and Functions

1 Reply

  • mathetes's avatar
    mathetes
    Gold Contributor
    Nov 14, 2021

    rbalza 

     

    I"ve never created a set of cascading drop downs as deep as you're trying to do, but I've done them three deep. They all follow the same conceptual frame. Here's an example only two deep. You can build on it. And with your table you already have a good start.

Resources