Peak Seagull
Member
Hi,
I’m trying to create some dynamic (cascading) dropdown lists and have been reading the Excel “Howto” https://chandoo.org/wp/dynamic-cascading-dropdowns-that-reset/
However, I’m struggling to get past the first part of adding =INDEX(Table1[[Choose…]],1):INDEX(Table1[[Choose…]],COUNTA(Table1[[Choose…]])) to my MainList without it erroring. I don’t know what I’m doing wrong – can someone help.
I’ve attached my spreadsheet which has a data entry tab where I want to show the drop-down lists. The asset column will eventually show the next level of drop-downs once I’ve got the first bit working.
Thank you for your help.
I’m trying to create some dynamic (cascading) dropdown lists and have been reading the Excel “Howto” https://chandoo.org/wp/dynamic-cascading-dropdowns-that-reset/
However, I’m struggling to get past the first part of adding =INDEX(Table1[[Choose…]],1):INDEX(Table1[[Choose…]],COUNTA(Table1[[Choose…]])) to my MainList without it erroring. I don’t know what I’m doing wrong – can someone help.
I’ve attached my spreadsheet which has a data entry tab where I want to show the drop-down lists. The asset column will eventually show the next level of drop-downs once I’ve got the first bit working.
Thank you for your help.