Match function

Show all
Collapse all
This article describes the syntax of the formula and the use of the function (function formula already written that takes a value or values, performs an operation and returns a value or values. Use functions to simplify and shorten formulas on a sheet of calculation, especially those who carry out lengthy or complex calculations.) MATCH Microsoft Office Excel.
Description
The MATCH function searches for a specified element in a range (range: two or more cells of a leaf. The cells in a range can be adjacent or not adjacent.) Cell, and then returns the relative position of that element in the range. For example, if the range A1: A3 contains the values 5, 25 and 38, the formula
= MATCH (25, A1: A3, 0)
returns the number 2, because 25 is the second element in the range.
Use MATCH instead of one of the Find feature when you need to know the position of an element in a range instead of the element itself. For example, you can use the MATCH function to provide a value for the row of the argument functions.
SintaxisCOINCIDIR (valor_buscado; matriz_buscada; tipo_de_coincidencia])
The syntax of the MATCH function has the following arguments (argument: a value that provides information to an action, an event, a method, a property, a function or procedure.)
valor_buscado Required. Value you want to search matriz_buscada. For example, when looking for a number in the telephone directory, use the person's name as the value of search, but the value you want is the phone number.
Valor_buscado The argument can be a value (number, text or logical value) or a cell reference to a number, text or logical values.
matriz_buscada Required. Range of cells in which the search is made.
tipo_de_coincidencia Optional. You can be the number -1, 0 or 1. The argument tipo_de_coincidencia specifies how Excel valor_buscado to coincide with the values matriz_buscada. The default value for this argument is 1.