MATCH
The MATCH identifier checks whether the specified value is an exact match to the column being searched.
Syntax
Arguments
column - The columns where the search needs to be performed. This is a required argument.
searchvalue - The value to be searched in the column. This is a required argument.
Example
Consider the below scenario where we need to close the sprint if the Q4 project status is 'Completed'. This has been achieved using the MATCH identifier as shown in the below image.
Excel equivalent
Last updated
