A step-by-step XLOOKUP tutorial for Google Sheets: left lookups, killing #N/A without IFERROR, returning four columns from one formula, slab lookups with match_mode -1, latest-record lookups with search_mode -1, and a bonus two-way lookup. Free practice file included.
