Forum Discussion

deedz7's avatar
deedz7
Copper Contributor
Aug 09, 2019

Drop down list

I want to create dependent drop down list but at the same time I want them to be automated (if possible). For example, say I've got a list of 5 car makers in my main drop down. Then I'll get to choose the models in the 2nd drop down. Once I've selected a specific model, I want the features/details of this model to show up in the 3rd or 4th column.

 

Can this be done?

excel
office 365

1 Reply

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Aug 09, 2019

    deedz7

     

    Hi,

     

    This is can be done by some tricks in data validations which involve the named ranges and INDIRECT function.

    Watch this https://www.youtube.com/watch?v=-78bH0RZ7MA to learn these tricks.

     

    Regards