Forum Discussion
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" function. 4 of 5 have max. 5 values for the 2nd drop down and work well. The fifth option has 60 values available, thereas the first 5 are ignored. Someone any ideas why? I am not aware of such a strong limitation in number of 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
7 Replies
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?
