XLOOKUP Return Multiple Columns at Once — One Formula, No Copy-Paste (2026)
XLOOKUP can return multiple columns at once — one formula, no copy-paste,
no helper columns. Here's the exact formula and why it works.
The formula:
=XLOOKUP(H2,A2:A13,B2:F13)
Look up the ID once, hand XLOOKUP the whole return range (B:F instead of a
single column), and the result spills across every field in that row. If the
columns you want aren't next to each other, wrap it in CHOOSECOLS — covered
at 2:20.
📗 Free workbook for this video: https://sheetlark.gumroad.com/l/xlookup-mu...
Chapters:
0:00 The problem — one XLOOKUP per column
0:25 The one-formula fix
1:00 Watch it spill across the row
1:30 Why the return range does the work
2:20 Non-adjacent columns with CHOOSECOLS
2:50 Prove it — change the Order ID
3:10 When NOT to use it — the #SPILL error
3:35 The Google Sheets version
Sheetlark. One spreadsheet fix at a time. 🐦