<div class="raw-html-embed">	<p>The <b>MATCH</b> function is one of the <a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#lookupreference" onclick="onhyperlinkclick(this)">lookup and reference functions</a>. It is used to return a relative position of a specified item in a range of cells.</p>

	<h5 class="pt8">Syntax</h5>
	<p><b><em>MATCH(lookup_value, lookup_array, [match_type])</em></b></p>
	<p>The <b>MATCH</b> function has the following arguments:</p>
	<table style="width: 40%">
		<tbody>
			<tr>
				<th style="background-color: #f4f4f4" width="150ch"><b>Argument</b></th>
				<th style="background-color: #f4f4f4"><b>Description</b></th>
			</tr>
			<tr>
				<td><b><em>lookup_value</em></b></td>
				<td>A value in the <em><b>lookup_array</b></em> to search for. It can be a numeric, logical or text value, or a cell reference.</td>
			</tr>
			<tr>
				<td><b><em>lookup_array</em></b></td>
				<td>A single row or column you need to analyze.</td>
			</tr>
			<tr>
				<td><b><em>match_type</em></b></td>
				<td>A type of match. It's an optional argument. The possible values are listed in the table below.</td>
			</tr>
		</tbody>
	</table>

	<p>The <b><em>match_type</em></b> argument can be one of the following:</p>
	<table style="width: 40%">
		<tbody>
			<tr>
				<th style="background-color: #f4f4f4"><b>Numeric value</b></th>
				<th style="background-color: #f4f4f4"><b>Meaning</b></th>
			</tr>
			<tr>
				<td><b><em>1 or omitted</em></b></td>
				<td>The values must be sorted in ascending order. If the exact match is not found, the function will return the largest value that is less than <em><b>lookup_value</b></em>.</td>
			</tr>
			<tr>
				<td><b><em>0</em></b></td>
				<td>The values can be sorted in any order. If the exact match is not found, the function will return the #N/A error.</td>
			</tr>
			<tr>
				<td><b><em>-1</em></b></td>
				<td>The values must be sorted in descending order. If the exact match is not found, the function will return the smallest value that is greater than <em><b>lookup_value</b></em>.</td>
			</tr>
		</tbody>
	</table>

	<h5 class="pt8">Notes</h5>
	<p><a href="../../docs/userguides/spreadsheet_editor/InsertFunction.aspx#howtoapplyfunctions_block" onclick="onhyperlinkclick(this)">How to apply</a> the <b>MATCH</b> function.</p>

	<h5 class="pt8">Examples</h5>
	<p>The figure below displays the result returned by the <b>MATCH</b> function.</p>
	<p><img alt="MATCH Function" src="https://static-helpcenter.teamlab.info/match_e2aa625b3f.png"></p></div>

MATCH Function

Docs

Argument	Description
*lookup_value*	A value in the lookup_array to search for. It can be a numeric, logical or text value, or a cell reference.
*lookup_array*	A single row or column you need to analyze.
*match_type*	A type of match. It's an optional argument. The possible values are listed in the table below.

Numeric value	Meaning
*1 or omitted*	The values must be sorted in ascending order. If the exact match is not found, the function will return the largest value that is less than lookup_value.
0	The values can be sorted in any order. If the exact match is not found, the function will return the #N/A error.
-1	The values must be sorted in descending order. If the exact match is not found, the function will return the smallest value that is greater than lookup_value.

MATCH Function

Syntax

Notes

Examples

Host ONLYOFFICE Docs on your own server or use it in the cloud