Last updated: 2/27/2026
The match function compares the first parameter with all the following ones and returns the number of the expression that matches. The comparison is case sensitive.
Syntax:
match( str, expr1 [ , expr2,...exprN ])
Tip noteIf you want to use case insensitive comparison, use the mixmatch function. If you want to use case insensitive comparison and wildcards, use the wildmatch function.
Examples and results:
| Example | Result |
|---|---|
| match( M, 'Jan','Feb','Mar') |
returns 2 if M = Feb. returns 0 if M = Aprorjan. |
