MATCH

Returns the index of a matched value

MATCH(value, column, match first)

Returns the index of a matched value.

Arguments

Argument	Description
value	Value to search.
column	Column to search for value.
match first	Optional, default 1. 1 matches first result found. 0 matches last result found.

Output

Index of matched value. If no match, returns null.

Example