Filter contains one of many

To filter data to include only records where a column is equal to one of many values, you can use the FILTER function together with the ISNUMBER function and MATCH function. In the example shown, the formula in F5 is: =FILTER(data,ISNUMBER(MATCH(color,list,0)),"No data") where data (B5:D15), color (C5:C15), and list (J5:J7) are named ranges.