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.
Thanks Hans
