For the complete documentation index, see llms.txt. This page is also available as Markdown.

MATCH

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.

Using the MATCH identifier

Excel equivalent

MATCH

Last updated

Was this helpful?