Problem with dependent data validation

Copper Contributor


I've created a name with the following formula:


In Table1 I have a matrix of products with their corresponding sizes. In the other table, the product names are the headers. Now I'd like to only be able to select the sizes that I have behind each product in Table1. Somehow it's not working with this formula. Does anyone have any ideas on how to approach this?

Table 1:



The other table:



3 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've attached the file :)


The define name Größe that you show in the first post refers to a sheet named Bestellformular.

The workbook that you attached does not contain this sheet, so the name Größe is not valid.