Problem with dependent data validation

Question

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:&nbsp;The other table:&nbsp;

hansvogelaar · Answer

user12690&nbsp;
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?

user12690 · Answer

Hi!I've attached the file 🙂

hansvogelaar · Answer

user12690&nbsp;
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.

Forum Discussion

Problem with dependent data validation

Resources