Hi, I am trying to create a multiple dependent dynamic data validation in multiple rows. I have tried doing it through name table / Indirect Function and it's working only in the first row.
In the Second Row (Column 1) when I am selecting different data, in that case in Column 2 its still showing me the options of the data that was selected in the first row and so on.
E.g. in the below data when I am selecting different Category in 2nd/3rd/4th row its still giving me an option of 1st row (Alpha) in Type/Subtype.
Can you please help me in resolving this issue.
In the Second Row (Column 1) when I am selecting different data, in that case in Column 2 its still showing me the options of the data that was selected in the first row and so on.
E.g. in the below data when I am selecting different Category in 2nd/3rd/4th row its still giving me an option of 1st row (Alpha) in Type/Subtype.
Can you please help me in resolving this issue.
Category | Type | Subtype |
Alpha | Meta | Sheen |
Beta | Centre | Keen |
Greta | Unicorn | Lean |
Charlie | Petal | Jean |