Forum Discussion
Help with a three-level cascading dropdown list
Hello, I can't seem to create three cascading dropdown lists in an Excel spreadsheet. I'm stuck at two levels and can't get the third one to work. Can someone please help me? Thank you in advance,...
Hi Hans,
The "TEMPS MEMO" column does not work for me. I have the list icon but no choice is possible.
The "TEMPS MEMO" column does not work for me. I have the list icon but no choice is possible.
You have to select an item from the drop-down in the MISS CODE column, then select an item from the drop-down in the PREST_CODE column in the same row. Only then should the drop-down in the TEMPS_MEMO column become populated.
The attached version uses a formula instead of data validation.
HansVogelaar I don't necessarily need the dropdown list but I need the label associated with the code.
Weird - it works for me:
But do you really need a drop-down for TEMPS_MEMO? You only have one choice for each selection in the PREST_CODE column...
HansVogelaar I understood but a priori for me it doesn't work by respecting the three steps. Column TEMPS_MEMO does not offer any choice.