Saturday, September 15, 2012

yogi_Update DropDown For An Item In Language of Choice From A Table Of Items In Multiple Languages

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #750   Sep 15, 2012

user barelief said: (!mydiscussions/docs/bS2QCp1jBzs)
Update dropdown list dynamically
I have a dropdown which should switch it's range after I choose another dropdown. 
Is there any smart way to make it update itself dynamically.
Here's spreadsheet in action [here], -- in this example when i choose a item from dropdown A12, -- the A16 dropdown list
should update according to it.


Thanks for any help or tip
following is a solution to a bit more generalized problem