deepcalc
DocsXMATCH

XMATCH

View as markdown/docs/functions/xmatch.md Ask Claude about this pageOpens Claude with this page's address

Returns the position of an item in a range or array.

  • Excel: Verified match
  • Google Sheets: No equivalent
  • Returns: Number

Examples

=XMATCH("gamma", C1:C5)
C
1 alpha
2 beta
3 gamma
4 delta
5 epsilon
Result 3

Syntax

XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])
lookup_value
any required
lookup_array
range required
match_mode
number optional
search_mode
number optional

Errors

#N/A
=XMATCH(42,A1:A2,3)
ADDRESSReturns a cell address as text from row and column numbers. AREASReturns the number of areas in a reference. HLOOKUPSearches first row and returns matching value. HYPERLINKThe text a link displays: clickability is the renderer's. INDEXReturns value at row and column in range. INDIRECTReturns reference specified by text string.