Forum Discussion

Nyssa1585's avatar
Nyssa1585
Copper Contributor
Jan 07, 2025

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

Resources