Using UNIQUE & FILTER formula inside the Data Validation toolbox

Question

Hello,

I'm trying to create multiple dependent dropdown list using the UNIQUE and FILTER formula directly inside the Data Validation Toolbox.

The formula (see below) I'm using is working well when outside of the toolbox (tested with F9) and return an array :

The Formula:

=UNIQUE(FILTER(INDIRECT("Table1[Package]"),INDIRECT("Table1[Level0]")=G2,"NOK"))

The returned array with F9:

{"Option A";"Option B"}

But for some reason, the same formula used inside the Toolbox evaluates to an error and the list is not working.

It is important for me to use the Toolbox as I want to repeat the dependent dropdown list in a dedicated form with several lines and each lines will have 4 columns to fill with dependent dropdown

I will really much appreciate any help on this one as I would like to avoid using the OFFSET methods that will be more complicated to implement.

Thanks for your support,

Answer 1

I have downloaded your file. Thank you for your sharing!