Problem with dependent data validation

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