deepcalc
DocsMATCH

MATCH

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

Returns position of value in a range.

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

Examples

=MATCH(30, A1:A10, 0)
A
1 10
2 20
3 30
4 40
5 50
Result 3

Syntax

MATCH(lookup_value, lookup_array, [match_type])
lookup_value
any required
lookup_array
range required
match_type
number optional

Errors

#N/A
=MATCH(100,{24,43.5,52.8,69},0)
#ERROR!
=MATCH(1,{1,2;3,4},0)
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.