Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to return multiple columns with XLOOKUP in Excel and Google Sheets
Topic:XLOOKUPExcel & Google Sheets
=XLOOKUP(A2, A$2:A$4, B$2:D$4)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Identify the lookup value in your dataset.
- 2Define the range where the lookup value exists.
- 3Specify the range containing the columns you want to return.
- 4Enter the XLOOKUP formula using the identified lookup value, lookup range, and return range.
Tips
- Ensure your lookup range and return range are correctly bounded to avoid errors.
- In Excel, XLOOKUP is available in Excel 2019 and later versions; check your version compatibility.
- Use named ranges for larger datasets to make formulas more readable.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
Can XLOOKUP return multiple columns?
Yes, XLOOKUP can return multiple columns by specifying a range of columns as the return range.
What if my lookup value is not found?
XLOOKUP will return #N/A by default if the lookup value is not found. You can specify an alternative return value using the fourth argument.
Is XLOOKUP available in all versions of Excel?
No, XLOOKUP is available in Excel 2019 and later versions, as well as in Google Sheets.
More on XLOOKUP
See all →Reference
XLOOKUP
The modern replacement for VLOOKUP and INDEX/MATCH — look up a value and return a match in any direction.
How-toHow to use XLOOKUP with multiple criteria
Concatenate criteria columns in XLOOKUP's lookup array to match on multiple conditions at once, returning results only when all criteria align.
Error fixFix #N/A
Fix #N/A errors in XLOOKUP in Excel and Google Sheets — lookup value not found, data-type mismatch, incorrect array size, and match mode issues.
How-toHow to use XLOOKUP with wildcards
Learn how to use XLOOKUP with wildcards to perform flexible lookups in Excel and Google Sheets.
Error fixFix #SPILL!
Fix #SPILL! errors from XLOOKUP in Excel — spill range blocked by non-empty cells, merged cells, or returning an array into a table column.