match - script and chart function
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. |