If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|