# 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/>" %}