Multiple Drop Down Lists

[Peak Seagull]

Hi,

I have used the INDIRECT function on the attached spreadsheet to link the drop down list under "Item" to the "Category" selected in the previous column. However, I would then like to link a "Colour" to the item selected from the drop down list in the "Item" column. If I use the INDIRECT function again I get the following box appear. Does anyone now how you can create multiple interdependent lists.

Thanks for your help.

Peak Seagull

 

[bosco_yip]

You have not setup Tier to the 3rd level "colour".

For example, if you choose "Bags", then what colour could be chosen? If you choose "Shoes", then what colour could be chosen?.....

You need to complete the 3rd level Tier setup as same as your 2nd level Tier for "Item", something like this :

 

[Peak Seagull]

You have not setup Tier to the 3rd level "colour".

For example, if you choose "Bags", then what colour could be chosen? If you choose "Shoes", then what colour could be chosen?.....

You need to complete the 3rd level Tier setup as same as your 2nd level Tier for "Item", something like this :
View attachment 70480

Thanks - i'll give it a go.

 

[Peak Seagull]

You have not setup Tier to the 3rd level "colour".

For example, if you choose "Bags", then what colour could be chosen? If you choose "Shoes", then what colour could be chosen?.....

You need to complete the 3rd level Tier setup as same as your 2nd level Tier for "Item", something like this :
View attachment 70480

Hi Bosco_yip,

I tried your suggestion but got the same message.

 

[Peak Seagull]

Hi Bosco_yip,

I tried your suggestion but got the same message.

Hi Again,
Apologies but I think I was doing it wrong yesterday - thought I would give it another go and it seems to be working.
Thanks a lot.