Problem with dependent data validation

[user12690]

Hi!

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:

[#2]

@user12690 

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?

[#3]

Hi!
I've attached the file :)

[#4]

@user12690 

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.