MATCH

Returns the position of the given value in the list

Usage

MATCH(list, value)

Parameters

list

(Required) The list to search in

value

(Required) The value to search for

Examples

Example With these variables Result

MATCH([“CAD”, “USD”], “USD”)

(None)

2

MATCH(currencies, “EUR”)

currencies is ["CAD", "USD"]

NOTHING

More information

The [ and ] mark the beginning and end of a list.

Unlike the Excel version of this function, the value must match exactly.

See also