MATCH

MATCH(arg1, arg2, arg3) → { number | string | boolean }

Returns the relative position of an item in an array that matches a specified value in a specified order.

Parameters:

Name Type Description
arg1 any

Is the value you use to find the value you want in the array, a number, text, or logical value, or a reference to one of these.

arg2 number

Is a contiguous range of cells containing possible lookup values, an array of values, or a reference to an array.

arg3 number

Is a number 1, 0, or -1 indicating which value to return..

Returns:

Type
number | string | boolean