# In

The **In** function tests if a value matches any candidate value in a subsequent list of candidate values. The function returns True if the value matches any of the subsequent candidate values, False if no values are matched.

### Usage

```
In(value, candidate 1,[candidates 2+])
```

Function arguments:

* **value** (required): The value to test.
* **candidate 1** (required): The candidates to test value against.
* **candidates 2+** (optional): The additional candidates to test value against.

> ### 📘
>
> At least one candidate value must be supplied to test the input ***value*** against.

### Example

```
In("green", "red", "green", "blue")
```

* Return True

```
In("yellow", "red", "green", "blue")
```

* Returns False

```
In([Customer ID], 2000, 3000, 4000)
```

* Returns True for rows where *Customer ID* is 2000, 3000, or 4000. Return False for all other rows.

```
In([Customers], "Customer 1", "Customer 2")
```

* Returns True for rows where *Customers* match “Customer 1” or “Customer 2”. Return false for all other rows.

```
In("John Smith", [Customers], [Buyers])
```

* Returns True for rows where “John Smith” appears in either the *Customers* or the *Buyers* columns.