Drop down list

Copper Contributor

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?

1 Reply

@deedz7

 

Hi,

 

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

Watch this video to learn these tricks.

 

Regards