For each of the three separate criteria above, we use a separate logical expression.

The output from FILTER is dynamic.

If source data or criteria change, FILTER will return a new set of results.

Excel formula: XLOOKUP with multiple criteria

For example, =LEFT(“apple”,3) returns “app”.

When given TRUE, NOT returns FALSE.

When given FALSE, NOT returns TRUE.

Excel formula: XLOOKUP basic exact match

Use the NOT function to reverse a logical value.

Excel formula: XLOOKUP with logical criteria

Excel formula: XLOOKUP latest by date

Excel formula: FILTER with complex multiple criteria

Excel FILTER function

Excel LEFT function

Excel MONTH function

Excel NOT function