Forum Discussion
deedz7
Aug 09, 2019Copper Contributor
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 choos...
Haytham Amairah
Aug 09, 2019Silver Contributor
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