View Single Post
  #1  
Old November 2nd, 2011, 11:34 AM
Emmaly Emmaly is offline
Member
 
First recorded activity by OfficeFrustration: Feb 2010
Posts: 6
Default Multiple Cascading Dropdowns

Hi All,

I have an issue with cascading dropdowns.

I have the following data. Entity = UK, GMBH, JAPAN, SING

I have then got lists of products, suppliers and customers specific to those entities.

So i can use the =INDIRECT(A2) to populate the first dropdown i have set up which are products which are called UK, GMBH, JAPAN, SING, but i also want to have it populate the suppliers and customers too.

They are not dependant on the choice of product so i can't use the =INDIRECT(SUBSTITUTE) function as the two further dropdowns are only dependant on the Entity on the first choice.

But I can't name all 3 dropdowns with one name as it won't know what to chose. Can i have a function along the lines of =INDIRECT(A2,UK_Suppliers) where it will then pick the list i have called UK_Suppliers.

If anyone could help i would be most grateful, i have a menacing hoard of directors bearing down on me to get this done!!

Thanks in advance