Forum Discussion

gsybon's avatar
gsybon
Copper Contributor
Jul 13, 2023
Solved

Nested drop down ignores some values

Hello together, I created a nested drop down. The first drop down uses list of 5 values. These 5 values are used as headers for a table giving the data for the 2nd drop down by means of an "indirect...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Jul 14, 2023

    gsybon 

    Thanks! Look at Formulas > Name Manager (Formeln > Namens-Manager).

    The defined name Rost refers to =Eingabe!$D$11:$D$65

    It begins in row 11 instead of row 6. Change the definition to =Eingabe!$D$6:$D$65

     

    Also, Entschlacker should refer to =Eingabe!$C$6:$C$10 instead of =Eingabe!$C$5:$C$10

gsybon's avatar
gsybon
Copper Contributor
Jul 14, 2023

HansVogelaar 

 

Now it should work:

https://energielink-my.sharepoint.com/:x:/g/personal/sybon_energielink_ch/ESALrjdrnYdJk-p0cyRhCvQBXkLz1jkuLkfOaK_LfhriSA?e=MxR0sE

HansVogelaar's avatar
HansVogelaar
MVP
Jul 14, 2023

gsybon 

Thanks! Look at Formulas > Name Manager (Formeln > Namens-Manager).

The defined name Rost refers to =Eingabe!$D$11:$D$65

It begins in row 11 instead of row 6. Change the definition to =Eingabe!$D$6:$D$65

 

Also, Entschlacker should refer to =Eingabe!$C$6:$C$10 instead of =Eingabe!$C$5:$C$10

  • gsybon's avatar
    gsybon
    Copper Contributor
    Jul 14, 2023
    That's it! You saved my day - dank u wel!

Resources