Multiple Dependent Dynamic Data Validation

[JoRao]

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.

Category	Type	Subtype
Alpha	Meta	Sheen
Beta	Centre	Keen
Greta	Unicorn	Lean
Charlie	Petal	Jean

 

[DanteAmor]

Hi and welcome to MrExcel!

I'm not getting what data goes in the data validation 1 and what data you want in data validation 2 after selecting the element from data validation1.
I attach a file with a different option on sheet1 and sheet2, so you can review them and see which one you need.
Review the formula at each data validation.

Test File

---