Feb 09 2023 10:24 AM - edited Feb 21 2023 04:21 AM
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:
Feb 10 2023 04:39 AM
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?
Feb 21 2023 04:10 AM
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.