Forum Discussion
Nested drop down ignores some values
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
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?
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
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?
Now it should work:
https://energielink-my.sharepoint.com/:x:/g/personal/sybon_energielink_ch/ESALrjdrnYdJk-p0cyRhCvQBXkLz1jkuLkfOaK_LfhriSA?e=MxR0sE
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