Data Validation from filtered query

[Jedi Master]

Hello everyone! I have a query of a list of equipment that each item in the list is, in one column, listed as active or inactive via "TRUE" or "FALSE". I would like to data validate a cell in a worksheet that looks for the Equipment number in my equipment list, but I only want the dropdown to list results of active("TRUE") equipment. Can anyone please direct me to how to do this?

 

[RoryA]

You'll need to use a range somewhere with the FILTER function - something like:

=FILTER(Tablename[Equipment number],Tablename[Active?]=TRUE)

to get a list of the valid numbers. Then define a named range that refers to that spilled range and use that name in the DV list.

 

[Jedi Master]

You'll need to use a range somewhere with the FILTER function - something like:

=FILTER(Tablename[Equipment number],Tablename[Active?]=TRUE)

to get a list of the valid numbers. Then define a named range that refers to that spilled range and use that name in the DV list.

Thank you very much! That worked perfectly.