Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
Earlier I had created a post yogi_Create A Dependent List Of Items Based On A List Of Items In A DropDown List
in this post I am going to Create A Dependent DropDown List Of Items Based On A List Of Items In A DropDown List (WOW ... a mouthful that sounds confusing to me!)
Well following is one solution to the problem
Earlier I had created a post yogi_Create A Dependent List Of Items Based On A List Of Items In A DropDown List
in this post I am going to Create A Dependent DropDown List Of Items Based On A List Of Items In A DropDown List (WOW ... a mouthful that sounds confusing to me!)
Well following is one solution to the problem
Hi Yogi:
ReplyDeleteYour solution seems to work; great work. However, it places the Dependent Subitems (column B) right in the spreadsheet (complicates). And it prevents me from using row 3 and subsequent rows because the array formula is using that space in column B. Is there a way to get ride of column B? Excel's validation function allows me to use source ranges to avoid this problem. Thanks.
John
What can be the method to reproduce this item/subitem link (with dropdown menu) for full columns. for example based on your example lets imagine that in a different tab, we want to have for each line the possibility to select in A1, A2, A3, A4, A5, ... an item and then in B1, B2, B3, B4, B5 the user may choose in the dropdown menu a subcategory accordling to the choice in item column A.
ReplyDeleteFor example if A1 has been choosen as Fruits, then B1 should allow to select (orange, grap, apple, mango), if in A2 'BakedGoods' ha sbeen selected, B2 may list Cake, Pastry, Pie....
Hi John:
ReplyDeleteHappy New Year!
Sorry for the delay in responding to your comment.
The way I have set it up ... it does need the dropDown column B ... you may however play with moving column B to a different column and see if that will work for what you need to do.
Cheers!
Yogi
Hi cilvin:
ReplyDeleteHappy New Year!
The setup I have made is for only one item to be selected, from cell A2 in column A.
Sorry, I have not worked it out for selecting multiple items from multiple cells in column A.
Cheers!
Yogi
Enjoy a wonderfull 2012 year, full of google usage :)
ReplyDeleteConcerning the usage of a Dependent DropDown List Of Items Based On A List Of Items In A DropDown List for several lines in the same column :) :) did you already see other people looking for that ? I spent few hours yesterday looking on "Google Docs Help Forum" without success.
do you think it's even possible ?
thank you very much
multiple items from multiple cells
Hi cilvin:
ReplyDeleteThanks for the New Year Greetings.
Concerning the usage of a Dependent DropDown List Of Items Based On A List Of Items In A DropDown List for several lines in the same column, I have not worked it out yet ... I suggest you post a question in Google Docs Help Forum with a clear sample along with your expected result ... this way the viewers will have a chance to see if and how this can be done.
Cheers!
Yogi
Cloud Computing -- Google Docs Way
yogi--anand-consulting.blogspot.com
hi... i have one problem in this sheet https://docs.google.com/spreadsheet/ccc?key=0AtZwzv4EAc54dHRoMDF4VUpfc29TZGNIT1RBMzFBVEE#gid=0 how can i make a drop down dynamic list ??
ReplyDeleteHi jacopo:
ReplyDeleteI have looke at your spreadsheet ...
try the following formula in cell E3:
=QUERY(A3:B, "SELECT B WHERE A='"&D3&"' ")
Let me know how it works out for you.
Make It A Great One
Cheers!
Yogi
Cloud Computing -- Google Docs Way
yogi--anand-consulting.blogspot.com