Forum Discussion
user12690
Feb 09, 2023Copper Contributor
Problem with dependent data validation
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 t...
HansVogelaar
Feb 10, 2023MVP
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?
- user12690Feb 21, 2023Copper ContributorHi!
I've attached the file 🙂- HansVogelaarFeb 21, 2023MVP
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.