In this example, we construct the array we need withboolean logic, also called Boolean algebra.
In Boolean algebra,multiplication corresponds to AND logic, and addition corresponds to OR logic.
Columns 2, 4, and 6 are removed.
In other words, the only columns that survive are associated with 1s.
Notice also that the third argument in MATCH is set as zero to force an exact match.
FILTER uses the array to remove columns 2, 4, and 6.
The output from FILTER is dynamic.
If source data or criteria change, FILTER will return a new set of results.
MATCH supports approximate and exact matching, andwildcards(* ?)
