- Document Solutions for Excel, .NET Edition Overview
- Key Features
- Getting Started
- Features
- Templates
-
Formula Reference
- Add-in and Automation Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
-
Lookup and Reference Functions
- ADDRESS
- AREAS
- CHOOSE
- CHOOSECOLS
- CHOOSEROWS
- COLUMN
- COLUMNS
- DROP
- EXPAND
- FILTER
- FORMULATEXT
- GETPIVOTDATA
- GROUPBY
- HLOOKUP
- HSTACK
- HYPERLINK
- IMAGE
- INDEX
- INDIRECT
- LOOKUP
- MATCH
- OFFSET
- PIVOTBY
- ROW
- ROWS
- SINGLE
- SORT
- SORTBY
- TAKE
- TOCOL
- TOROW
- TRANSPOSE
- TRIMRANGE
- UNIQUE
- VLOOKUP
- VSTACK
- WRAPCOLS
- WRAPROWS
- XLOOKUP
- XMATCH
- Math and Trigonometry Functions
- Statistical Functions
- Text Functions
- Web Functions
- File Operations
- Document Solutions Data Viewer
- API Reference
- Release Notes
MATCH
This function returns the relative position of a specified item in a range.
Syntax
MATCH(value1, array, [type])
Arguments
You can use a single array (cell range) instead of a list of values. You can use multiple arrays (cell ranges) as well.
Argument | Description |
|---|---|
value | [Required] Value to search for |
array | [Required] Range to search in |
type | [Optional] Value to return if the formula returns an error |
Remarks
The value can be a number, text, or logical value, or a cell reference to a number, text, or logical value. The array is the range of cells to search.
The type can be 0 (first value that is equal to value), 1 (largest value that is less than or equal to value), or -1 (smallest value that is greater than or equal to value) and is optional.
Examples
MATCH(25,A1:E5)