Forum Discussion
Nyssa1585
Jan 07, 2025Copper Contributor
Multidependent drop down lists using Unique, Filter and Offset functions
Hi there,
I am trying to create a muilti use dashboard to track certain issues across time, but I want to establish a predefined list of common issues and categories for the user to select.
The first tab is my lists I want to include. The second tab is where the data validation lists are for user selection.
In that second tab,
- in cell A6 I have referenced the D3 cell for the =UNIQUE(Table1[Tag]) from the first tab cell
- in cell B6 I have refercence the E3 cell for the =UNIQUE(FILTER(Dropdowns2!B:B,Dropdowns2!A:A=January!A6)) from the frist tab
- In cell C6 I am trying to use the Offset function =OFFSET(Dropdowns2!$B$35,1,MATCH(January!B6,Dropdowns2!$B$35:$AB$35)-1,17,1) but it keeps stating that there is an error and it will pull the wrong data set from the wrong main category.
Can anyone help with this issue?
1 Reply
- Harun24HRBronze Contributor
Can you please attach a sample file?