Forum Discussion
Solved
Unable to create dependency drop down List
Hello All, After a long search I still could not figure out how to create this dependency drop down list in excel. What should I input in Data validation:List? May I have your help on it: My t...
Create Data Validation of type List with formula
=OFFSET(Second!$B$1, XMATCH(A2, Second!$A$2:$A$1000), 0, COUNTIF(Second!$A$2:$A$1000, A2), 1)
See the attached demo workbook.
Hi Hans,
Thank you so much, it works.
May I ask one more: the pre-requisite of this setup is all rows need to in order in sheet:Second.
If it is not in order, error occurs as below.
Can the drop down list still works for this case?
Thank you.
No, the rows for one item should be adjacent. Otherwise it becomes very complicated.