MATCH function is rarely used independently. The counting is performed not from 0 (zero), as it is implemented in many programming languages when working with arrays, but from 1. If arrays are used for constants, which can be represented as arrays of “key” - “value” elements, the FIND function returns a key value that is not explicitly specified.įor example, the array ,0) returns the value 2, which is the key of the second element. This function is convenient for use in cases when it is necessary to return not the value contained in the desired cell, but its coordinate relative to the range in question. Function =MATCH(3,B1,B10,0) will return the number 3, because the desired value is in cell B3, which is the third from the point of reference (cell B1). Examples of using the MATCH function in Excelįor example, we have a series of numbers from 1 to 10, written in cells B1:B10.
