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.
Hello,
I did the same OFFSET function for more mixed data however it gives wrong results. Such Small example data is as follows:
| Type | Short Name |
| Factory | A Company |
| Customer | B Company |
| Factory | C Company |
| Customer | D Company |
if you use offset or indirect, it doesnot help unfortunately, which i have trying to solve this for hours now. Very sad on this. can you guys help please?
