MATCH
Returns the index of a matched value
MATCH(value, column, match first)
Returns the index of a matched value.
Arguments
Output
Index of matched value. If no match, returns null.
Example
Last updated
Returns the index of a matched value
MATCH(value, column, match first)
Returns the index of a matched value.
Index of matched value. If no match, returns null.
Last updated
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.