Checks whether a specified value exactly matches the searched column value.
The MATCH identifier checks whether the specified value is an exact match to the column being searched.
Syntax
MATCH(column,searchvalue)
Arguments
column - The column 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 image below.
