Reddit
reddit.com › r/googlesheets › problem using xlookup in sheets
r/googlesheets on Reddit: Problem Using XLOOKUP in Sheets
June 9, 2023 -
In a google sheet of mine, I'm trying to use XLOOKUP to search the input of a cell for a partial match to a range of cells in another sheet. Here are 3 ways I've tried.
=XLOOKUP(A1,'Plant Orders'!B3:B1001,'Plant Orders'!B3:B1001,"Nothing",2)
=XLOOKUP(A1,'Plant Orders'!B2:B1000,'Plant Orders'!B2:B1000,"unknown",1)
=INDEX('Plant Orders'!B2:B1000, MATCH(A1,'Plant Orders'!B2:B1000,1))
All of these options are causing errors in different ways.
Option 1 requires an exact match.
Option 2 can do partial matches, but seems to return a random cell if there aren't any 'real' partial matches.
Option 3 is similar to 2.
I've used XLOOKUP in excel and had no issue with returning partial matches correctly. I'm not sure what the difference is with google sheets.
xlookup doesnt return value from query unless query cell has enter pressed Jun 3, 2021
r/excel 5y ago
Xlookup on google sheets vs. excel - Array arguments to xlookup are of a different size Nov 7, 2023
r/googlesheets 2y ago
XLOOKUP is returning a random value, or nothing at all. Not sure if XLOOKUP is the right formula to use Mar 21, 2025
r/excel last yr.
Google Support
support.google.com › docs › thread › 301238813 › i-have-an-xlookup-function-that-is-working-in-one-tab-but-not-the-other-and-i-cannot-figure-out-why
I have an XLookup function that is working in one tab, but not the other and I cannot figure out why - Google Docs Editors Community
October 9, 2024 - 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
Xlookup not working in Sheets - 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
How 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, 2024XLOOKUP will not allow to lookup the entire column. For Google Sheets.
Dear Excel Experts, I have a below formula whereby it returns the name with the closest date from today's date... More on mrexcel.com
7
0
May 27, 2024XLOOKUP in Google Sheets works only on the first line with the searched value - Stack Overflow
Bring the best of human thought ... at your work. Explore Stack Internal ... I've got a problem with populating whole table in Google sheets. I want to pull out all the data rows based on one product name from A2 cell. I've created such formula, which taking the data from another sheet and give us searched details. From such base I want to look up all the details enter image description here · Formula I used in B5 cell is enter image description here · =xlookup($A$2,IMPO... More on stackoverflow.com
What 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
How to use XLOOKUP in Google Sheets
05:41
Avoid Common XLOOKUP Errors and Issues - YouTube
Master Google Sheets with the XLOOKUP Function | Complete Guide ...
26:28
Common Formula Errors in Google Sheets and How To Fix Them - YouTube
15:01
How to Use XLOOKUP in Google Sheets - YouTube
Google Sheets How to Use Xlookup in Multiple Columns
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
Google Support
support.google.com › docs › thread › 302726383 › xlookup-not-working-in-sheets
Xlookup not working in Sheets - Google Docs Editors Community
October 18, 2024 - 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
Ben Collins
benlcollins.com › home › xlookup function in google sheets
XLOOKUP Function in Google Sheets
February 7, 2024 - It works like a charm! =IFERROR( ARRAYFORMULA( XLOOKUP(A2:A;’YourTable’!A2:A;’YourTable’!B2:B)) 😉 ... hi Ben, love your website and advice. I’m usually an Excel user but sometimes have to use Sheets for other clients. Have you ever noticed an issue with XLOOKUP and multiple criteria generating errors where the same formula in Excel doesn’t?
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.
Dashboarddr
dashboarddr.com › google-sheets › vlookup-xlookup › troubleshooting
Google Sheets VLOOKUP & XLOOKUP: Troubleshooting & Fixes — Free Expert Guide 2025 | DashboardDr
March 16, 2026 - These are the tips that separate Google Sheets power users from beginners when working with vlookup & xlookup: ... Always use absolute references ($A$2:$B$100) in VLOOKUP ranges to prevent broken lookups when dragging formulas ... XLOOKUP is more flexible than VLOOKUP — it searches in any direction and returns custom values when nothing ...
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.
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))
MrExcel
mrexcel.com › forums › question forums › general discussion & other applications
XLOOKUP will not allow to lookup the entire column. For Google Sheets. | MrExcel Message Board
May 27, 2024 - May I know if there would be any alternate function that is workable in Google Sheets? ... What version of Excel are you using, as 2016 doesn't have Filter or Xlookup? I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’) How about ... =LET(f,FILTER(I2:P10000,E2:E10000=R2),XLOOKUP(TODAY(),TAKE(f,,-1),TAKE(f,,1),XLOOKUP(TODAY(),TAKE(f,,-1),TAKE(f,,1),,-1),1))
Write My Formula
writemyformula.com › write my formula › google sheets xlookup repair
Google Sheets XLOOKUP Not Working? | Write My Formula
Use this page when Google Sheets XLOOKUP returns #N/A, returns the wrong duplicate match, shows a blank or misleading fallback, breaks after a range edit, or depends on match_mode and search_mode choices you are not sure about.
Stack Overflow
stackoverflow.com › questions › 76754063 › xlookup-in-google-sheets-works-only-on-the-first-line-with-the-searched-value
XLOOKUP in Google Sheets works only on the first line with the searched value - Stack Overflow
Bring the best of human thought and AI automation together at your work. Explore Stack Internal ... I've got a problem with populating whole table in Google sheets. I want to pull out all the data rows based on one product name from A2 cell. I've created such formula, which taking the data from another sheet and give us searched details. From such base I want to look up all the details enter image description here · Formula I used in B5 cell is enter image description here · =xlookup($A$2,IMPORTRANGE("https://docs.google.com/spreadsheets/d/1O1AF3JewmhEoly_dhFWbkax-T5Q7oeQKYjia-Ci1vd0/edit#gid=201","SKUDatabase!B:B"),IMPORTRANGE("https://docs.google.com/spreadsheets/d/1O1AF3JewmhEoly_dhFWbkax-T5Q7oeQKYjia-Ci1vd0/edit#gid=201","SKUDatabase!A:A"))
Google Support
support.google.com › docs › thread › 32509508 › does-xlookup-formula-work-it-to-google-sheet
Does xlookup formula work it to google sheet ? - Google Docs Editors Community
June 3, 2020 - 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
Google Support
support.google.com › docs › thread › 177871473 › new-sheets-feature-xlookup-was-added-but-then-it-disappeared-a-day-later
New Sheets feature XLOOKUP() was added, but then it disappeared a day later? - Google Docs Editors Community
September 4, 2022 - 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
Sheetgo
sheetgo.com › home › how to use xlookup in google sheets? (+ formulas and examples)
How to use XLOOKUP in Google Sheets? | Sheetgo
June 3, 2025 - Can you use XLOOKUP to return multiple results in Google Sheets? Not really. XLOOKUP typically returns a single match or the first match it finds. Unfortunately, it does not natively support returning multiple matches as FILTER does. So, in its standard form, XLOOKUP is unsuitable for pulling various rows. Did you notice that I mentioned FILTER? How does it work...
Google Support
support.google.com › docs › thread › 227623815 › xlookup-in-googlesheet
XLOOKUP in GoogleSheet - Google Docs Editors Community
July 27, 2023 - 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
SimonsezIt
simonsezit.com › article › xlookup-in-google-sheets
XLOOKUP in Google Sheets - 4 Best Alternatives
June 21, 2023 - Use the equivalent functions in Google Sheets to perform an Excel XLOOKUP on a dataset. ... XLOOKUP does not (yet!) exist in Google Sheets.
Spreadsheet Point
spreadsheetpoint.com › home › google sheets tips › the ultimate guide to the xlookup google sheets function
Guide to the XLOOKUP Google Sheets Function [2026] | SSP
August 18, 2023 - You can use XLOOKUP instead of VLOOKUP in Excel, and the only difference is that XLOOKUP will work no matter the direction of the lookup, and the returned values will reside in the array or cell range. Unfortunately, XLOOKUP does not work in Google Sheets.
Coupler.io Blog
blog.coupler.io › home › xlookup google sheets explained with 9 examples
XLOOKUP Google Sheets Guide (With Examples) | Coupler.io Blog
August 5, 2025 - The error message that should be displayed if no result is found (e.g., “Nothing found”). If omitted, the #N/A error will be displayed instead. ... You may be familiar with the first two selections. In the classic VLOOKUP, ‘1’ is the equivalent of TRUE (approximate match), while ‘0’ works the same way as the default FALSE (exact match). In XLOOKUP Google Sheets, ‘0’ (exact match) is used as a default.