MATCH

The MATCH identifier checks whether the specified value is an exact match to the column being searched.

Syntax

match(column, searchvalue)

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.

Using the MATCH identifer

Excel equivalent

MATCH