Forum Discussion

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
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

Copper Contributor

Jul 14, 2023

HansVogelaar

I didn't find a possibility to attach files, so I tried my best to show the situation. Values in column D are only avalilable from D11 on, all others start with C/E/F/G6

HansVogelaar

MVP

Jul 14, 2023

gsybon

I'm afraid that doesn't help. Can't you upload a file to OneDrive or Google Drive, share it and copy/paste a link in a reply?

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
  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
    Copper Contributor
    Jul 14, 2023
    That's it! You saved my day - dank u wel!