Monday, December 12, 2011

yogi_Handle Multiple Dependency Lists And Computations

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user Loki said:
I've been reading a couple of your posts on the above subject, and looking at the 'screenshot' embedded example(s):
http://yogi--anand-consulting.blogspot.com/2011/11/yogicreate-dependent-dropdown-list-of.html
http://yogi--anand-consulting.blogspot.com/2011/10/yogicreate-dependent-list-of-items.html
It's very interesting (I've never even used named ranges), and looks like it would solve my problem - but I'm not sure how to implement it from what I've read there.
I'm probably just being stupid. Would you mind looking at my spreadsheet? I've made it public:
https://docs.google.com/spreadsheet/ccc?key=0AkDJZNlbZvaCdEgtbXBjWVFYcXB1WFhvZi1WNThlTmc&hl=en_GB#gid=0
I want to have CATEGORIES on the COCKTAILS sheet which then affect subcategories, i.e. the available INGREDIENTS.
And I'd also like both data validated dropdown boxes here to be populated from the full details on the INGREDIENTS sheet.
Is this achievable using the method you posted? If so, help implementing it would be amazing! If not, any ideas?

------------------------------------------------
following is a solution to the problem: