Google Support
support.google.com › docs › answer › 12405947
XLOOKUP function - Google Docs Editors Help
XLOOKUP(search_key,lookup_range,result_range,missing_value,match_mode) search_key: The value to search for. For example, 42, "Cats", or B24. search_column: The column to consider for the search. result_column: The column to consider for the result. missing_value: [OPTIONAL - #N/A by default] The value to return if no match is found. match_mode: [OPTIONAL - 0 by default] The manner in which to find a match for the search_key.
Ben Collins
benlcollins.com › home › xlookup function in google sheets
XLOOKUP Function in Google Sheets
February 7, 2024 - Learn about the XLOOKUP function in Google Sheets, the powerful successor to the VLOOKUP. Does left lookups, bottom-to-top search, and more.
google sheets - How do I use XLOOKUP for multiple criteria? - Stack Overflow
Remember that XLOOKUP finds the first match, if you have multiple matches, you need to join the result for example. ... This formula will error out in Google Sheets. To make it work, wrap it in arrayformula(). More on stackoverflow.com
Excel formula like "XLOOKUP" does not function in google sheet - Google Docs Editors Community
Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on More on support.google.com
Excel Adds XLOOKUP. Coming for Google Sheets?
It is almost certain to come go Sheets in the future. Not because it is a necessary feature, but because Google wants to make sure you can take any .xlsx file and upload it for use in Sheets. A few months ago there was a huge formula dump for this very reason - to add compatibility with Excel files uploaded. More on reddit.com
19
18
September 13, 2019How do I make XLOOKUP work in Google Sheets?
For B14, to the value of Jan and AA (5) =Match(A14,A1:A8,0) will give you you a row value for where AA is in your table (2) =Match(B13,A1:M1,0) will give you the column value where Jan is for the row A1:M1 (2) Now you can use Index to return the value that intersects with your row and column =index(table, row, column). Or with the row and column substituted with your Match() formulas: =index(A1:M8, Match(A14,A1:A8,0), Match(B13,A1:M1,0)) More on reddit.com
8
1
May 22, 2024What is the XLOOKUP syntax in Google Sheets?
=XLOOKUP(search_key, lookup_range, result_range, [missing_value], [match_mode], [search_mode]). The first three are required. missing_value defaults to #N/A, match_mode defaults to 0 for an exact match, and search_mode defaults to 1 for first to last.
simplesheets.co
simplesheets.co › blog › xlookup-google-sheets
XLOOKUP in Google Sheets: Syntax, 7 Examples and Fixes
Can XLOOKUP pull data from another spreadsheet?
Yes, by wrapping each range in IMPORTRANGE. You have to approve the connection between the two files first by running a bare IMPORTRANGE in a spare cell and clicking Allow access. Nesting it inside XLOOKUP before approval returns an error without ever showing the prompt.
simplesheets.co
simplesheets.co › blog › xlookup-google-sheets
XLOOKUP in Google Sheets: Syntax, 7 Examples and Fixes
How is XLOOKUP different from VLOOKUP?
XLOOKUP takes the lookup range and the result range as separate arguments instead of a column number, so it can return values to the left of the key and can search across a row as well as down a column. It also defaults to an exact match and has a built in value for when nothing is found.
simplesheets.co
simplesheets.co › blog › xlookup-google-sheets
XLOOKUP in Google Sheets: Syntax, 7 Examples and Fixes
00:33
Learn The XLOOKUP Function | Google Sheets - YouTube
06:08
How to use XLOOKUP in Google Sheets - YouTube
Master Google Sheets with the XLOOKUP Function | Complete Guide ...
00:56
How to do an XLOOKUP in Excel or Google Sheets - 12 Days of ...
03:35
How to Use XLOOKUP in Google Sheets Why It’s Better Than VLOOKUP ...
Reddit
reddit.com › r/googlesheets › how do i make xlookup work in google sheets?
r/googlesheets on Reddit: How do I make XLOOKUP work in Google Sheets?
May 22, 2024 -
I have data in google sheets that looks like what I have below. I am trying to populate a value by referencing two cells, vertical and horizontal. I want the formula to return the figure where the horizontal and vertical reference points meet.
My Google Sheets formula looks like this =XLOOKUP(L6,Sheet1!A1:BB1,XLOOKUP(E58,Sheet1!A3:A78,Sheet1!B3:AE85,0,0,1))
However I keep getting an error - array arguments to xlookup are of different size. Is there a better way of doing this?
The source data and the documents with the formulas are in the same file but different worksheets.
The image below is just an example
Top answer 1 of 4
3
Your screenshot appears to be excel. Are you using excel or google sheets?
2 of 4
2
For B14, to the value of Jan and AA (5) =Match(A14,A1:A8,0) will give you you a row value for where AA is in your table (2) =Match(B13,A1:M1,0) will give you the column value where Jan is for the row A1:M1 (2) Now you can use Index to return the value that intersects with your row and column =index(table, row, column). Or with the row and column substituted with your Match() formulas: =index(A1:M8, Match(A14,A1:A8,0), Match(B13,A1:M1,0))
InfoInspired
infoinspired.com › home › google docs › spreadsheet › xlookup in google sheets: complete guide
XLOOKUP in Google Sheets: Complete Guide
3 weeks ago - HomeGoogle DocsSpreadsheetXLOOKUP in Google Sheets: Complete Guide ... XLOOKUP is a modern lookup function in Google Sheets that can perform both vertical and horizontal lookups.
SimpleSheets
simplesheets.co › blog › xlookup-google-sheets
XLOOKUP in Google Sheets: Syntax, 7 Examples and Fixes
November 8, 2024 - Google Sheets does have XLOOKUP. Full syntax, match_mode and search_mode tables, 7 worked examples, and fixes for #N/A and #VALUE errors.
Layer
golayer.io › home › xlookup in google sheets (+ examples)
XLOOKUP in Google Sheets (+ Examples) | Layer Blog
July 17, 2024 - The XLOOKUP function in Google Sheets allows you to perform complex lookups, horizontally and vertically, without having to resort to combining the INDEX and MATCH functions.
Alice Keeler
alicekeeler.com › home › google › how to use xlookup in google sheets
How to Use XLOOKUP in Google Sheets - Teacher Tech with Alice Keeler
October 15, 2024 - =XLOOKUP(A2,’Contact Info’!C2:C11,’Contact Info’!E2:E11) Notice the lookup values are on a different sheet than where I am recording the log entry.
Google Workspace
workspace.google.com › marketplace › app › xlookup_for_sheets › 319859325063
Xlookup for Sheets - Google Workspace Marketplace
With XLOOKUP google sheet function, you can look in one column for a search term and return a result from the same row in another column, regardless of which side the return column is on.
Hooshmand
hooshmand.net › xlookup-in-google-sheets-equivalent
XLOOKUP in Google Sheets — 2 Equivalents and Alternatives
December 31, 2023 - XLOOKUP is a really nice improvement over VLOOKUP, and is a simplification of INDEX(MATCH). And while it may come to Google Sheets in the future, there’s no direct equivalent now.
Simular
simular.ai › workflow › how-to-master-xlookup-in-google-sheets-a-smart-guide
How To Master XLOOKUP in Google Sheets: A Smart Guide
August 13, 2026 - ... Goal: Look up a value (like a client ID) and return a related value (like MRR). ... Organize your data so the key you want to search is in one column (the lookup range) and the result you want is in another (the result range).
XLOOKUP
xlookup.co.uk › home › xlookup google sheets not available? here’s what to do
XLOOKUP in Google Sheets: Fixes & Alternatives
February 23, 2026 - XLOOKUP not working in Google Sheets? Discover the best alternatives—FILTER, INDEX/MATCH, VLOOKUP, and QUERY.
YouTube
youtube.com › playlist
Google Sheets XLookup Function Examples - YouTube
This playlist covers the Google Sheets XLookup Function. This function was added to Google Sheets in 2022.
Simular
simular.ai › workflow › how-to-master-xlookup-in-google-sheets-a-guide
How to Master XLOOKUP in Google Sheets: A Guide
December 26, 2025 - If you live in Google Sheets, XLOOKUP is the lookup function you reach for when VLOOKUP keeps getting in your way. It searches in any direction, works with both rows and columns, supports wildcards, and lets you control what happens when there’s ...
Softr
softr.io › home › blog › 100 google sheets formulas that actually work: a cheat sheet
How to use XLOOKUP in Google Sheets - Guide
July 23, 2026 - It supports both A1 and R1C1 notation via its second argument, and is often used to build references that shift with a dropdown, though it can slow down large sheets since it recalculates constantly. ... Returns the value stored in cell A1. Using INDIRECT in a Google Sheet.
Simular
simular.ai › workflow › how-to-master-xlookup-in-google-sheets-excel-guide
How to Master XLOOKUP in Google Sheets & Excel Guide
February 22, 2026 - Step-by-step XLOOKUP in Google Sheets and Excel, then hand repetitive spreadsheet lookups to an AI computer agent so your team can focus on revenue work.
Medium
medium.com › @pastranaarias.nicole › mastering-xlookup-in-google-sheets-referencing-data-from-a-separate-spreadsheet-9bdc7300e393
Mastering XLOOKUP in Google Sheets: Referencing Data from a Separate Spreadsheet | by Nicole Pastrana | Medium
March 6, 2024 - =XLOOKUP( A2, //search_key IMPORTRANGE('GOOGLESHEET-URL-HERE','SheetNAME!A:A'), //lookup_range IMPORTRANGE('GOOGLESHEET-URL-HERE','SheetNAME!B:D')) //result_range ... I'm all about delving into data, files, and spreadsheets!
Top answer 1 of 2
14
It is usually easier to use filter(), like this:
=filter('Master Data'!D2:D9, C3 = 'Master Data'!A2:A9, C4 = 'Master Data'!C2:C9)
To answer the question, to do the same with xlookup(), you can combine columns into a compound key, as attempted by the formula in the question. To combine columns of multiple rows with the & operator, you need to wrap the expression in arrayformula(), like this:
=xlookup(
C3 & "→" & C4,
arrayformula('Master Data'!A2:A9 & "→" & 'Master Data'!C2:C9),
'Master Data'!D2:D9
)
See your sample spreadsheet.
2 of 2
2
you can even use the Multiple Criteria Boolean Expressions XLOOKUP functionality
=XLOOKUP(1,ARRAYFORMULA(('Master Data'!A2:A9=C3)
*('Master Data'!$C$2:$C$9=C4)),'Master Data'!D2:D9,,0)
Here is a simple example:
Here is the formula associated with the previous example:
=XLOOKUP(1,ARRAYFORMULA((A2:A3=F2) * (B2:B3=F3)),C2:C3)
The formula can be adapted from Excel, check: XLOOKUP with multiple criteria.
Remember that XLOOKUP finds the first match, if you have multiple matches, you need to join the result for example.
mapflo
mapflo.io › home › xlookup in excel and google sheets
XLOOKUP in Excel and Google Sheets - mapflo
October 12, 2025 - You need to use concatenate to join together dimensions that together create unique values (this can be two or more criteria). You can then xlookup the concatenated value in the secondary dataset to append values from that dataset to the initial ...
Google Support
support.google.com › docs › thread › 311954503 › excel-formula-like-xlookup-does-not-function-in-google-sheet
Excel formula like "XLOOKUP" does not function in google sheet - Google Docs Editors Community
Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on
How-To Geek
howtogeek.com › home › web › how to use xlookup in google sheets
How to Use XLOOKUP in Google Sheets
October 5, 2022 - With the XLOOKUP function and accompanying formula, you can perform a lookup in one cell range and return a matching result from another. This is handy for sheets that contain a lot of data where using your eyeballs is time-consuming. Related: How to Use INDEX and MATCH in Google Sheets