https://www.youtube.com/watch?v=Z7hPEwCzk2s

00:00 — XLOOKUP overview

01:00 — What XLOOKUP returns and inputs

02:00 — Lookup value and array explained

03:00 — Return array and example setup

04:00 — Drag to fill and multiple return columns intro

05:00 — Multiple return columns behavior

06:00 — Exact match, IFNOTFOUND, and match mode

07:00 — Wildcards in match mode

08:00 — More wildcard examples

09:00 — Search order intro and next larger example

10:00 — Search mode: first-to-last vs last-to-first

11:00 — Combining match and search modes

12:00 — Horizontal XLOOKUP example

13:00 — SUM with XLOOKUP over a range

14:00 — Complete SUM with XLOOKUP

15:00 — XLOOKUP vs VLOOKUP overview