> For the complete documentation index, see [llms.txt](https://docs.cascade.io/cascade/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.cascade.io/cascade/functions-and-expressions/functions/table/match.md).

# MATCH

MATCH(`value`, `column`, `match first`)

Returns the index of a matched value.

### Arguments

| Argument      | Description                                                                           |
| ------------- | ------------------------------------------------------------------------------------- |
| `value`       | Value to search.                                                                      |
| `column`      | Column to search for `value`.                                                         |
| `match first` | Optional, default `1`. `1` matches first result found. `0` matches last result found. |

### Output

Index of matched value. If no match, returns `null`.

### Example

{% embed url="<https://datawrapper.dwcdn.net/jtFhK/2/>" %}