Learn when FILTER beats XLOOKUP, when it does not, and how to handle multiple matches, nth items, and multi-condition lookups with clear steps.

Here is a simple-looking visual trick challenges your perception of two lines. What you see may surprise you, revealing how ...