Function MATCH

Returns the position of the given value in the list

Usage

MATCH(list, value)

list	(Required) The list to search in
value	(Required) The value to search for

Example	With these variables	Result
MATCH([“CAD”, “USD”], “USD”)	(None)	2
MATCH(currencies, “EUR”)	currencies is ["CAD", "USD"]	NOTHING

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

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