While Schrempf meticulously tracked his shooting splits, he also made a habit of checking the box score after every game. But ...
Learn when FILTER beats XLOOKUP, when it does not, and how to handle multiple matches, nth items, and multi-condition lookups with clear steps.