MATCH

Use the MATCH function to search for the specified value in an array and return the relative position of that value. The search is case-insensitive and can include wildcard characters question mark (?) and asterisk (*). A question mark matches any single character; an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.

Use

MATCH( value, array )
Searches for a specified value in an array and returns the relative position of that value.

Parameter	Required	Description
value	Yes	the value to search for, including wildcards ? and *
array	Yes	the array to search

Returns

Number

Example

This section isn’t ready just yet—we’re working on it! Please check back soon, and if you need help right away, feel free to ask in our Community Forum.