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

HansVogelaar

MVP

Jul 13, 2023

gsybon

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

gsybon
Copper Contributor
Jul 14, 2023
HansVogelaar
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