Forum Discussion

Riazz027's avatar
Riazz027
Copper Contributor
Jan 03, 2025

Cascading Data Validation 3 level dropdown list with reoccurring text

Good day,

I want to make a 3 level cascading dropdown list but the 3d level is not working. 

My idea is to make a budget tracker from 2 banks (Level 1) from which each bank has 3 accounts (Level 2)  and each account has a different currency (Level 3). The problem arises when different accounts have the same currency. 

The system does not seem to be able to read it and returns a blank dropdown.

Is there a way around it?

 

attached is the link to the file:

Excel questions

 

Feel free to reach out if there are any questions.

 

Thank you in advanced

  • Do you really need a drop-down in the Currency column? Each account has only one currency, so a lookup formula should be sufficient. See the attached version. I created a table with a different layout for the lookup.

  • Do you really need a drop-down in the Currency column? Each account has only one currency, so a lookup formula should be sufficient. See the attached version. I created a table with a different layout for the lookup.

    • Riazz027's avatar
      Riazz027
      Copper Contributor

      It is not required to be a drop-down, no. A drop-down seemed the easiest at the time. 

      This will work fine. Thank you.

      Appreciate it 😄

Resources