( by Robert )
Hi I, want to create a dropdown list in google drive excel.
Now to have dropdown list depending on another dropdown list in Google Spreadsheet, you have to do a work around.
Following Example will show you how to achieve this.
Let's have a Sheet 'Main Sheet', and in that sheet we have a dropdown in Cell B1. Have a look at the following screenshot:
We have validated the data from the list, that is 'DropDown List'!A1:C1
And following is the screenshot of Sheet 'DropDown List':
=arrayformula(if('Main Sheet'!B1=A1;A3:A6;if('Main Sheet'!B1=B1;B3:B6;if('Main Sheet'!B1=C1;C3:C6;""))))
So, now if user select "liquid" in Cell B1 of Main Sheet then Column E of 'DropDown List' will be populated by B3:B6
And now is the main important part of this tutorial. Now in Cell A2 of Sheet 'Main Sheet' you can validate the data from 'DropDown List'!E1:E100
So you will be now having a dropdown list based on another dropdown list. Have a look at the screenshot below:
Now if you change the data in Cell B1, then the contents of data validation of Cell B2 will automatically change. Have a look at the following screenshot of Sheet 'Main Sheet':
I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.