---
title: "Use the IN Function to Check If Items Exist in a List or Range"
slug: "in-function"
description: "Learn to simplify validations in Pigment with the IN function by checking if values are in a List or fall within a specified range."
updated: 2026-01-13T14:39:09Z
published: 2026-01-13T14:39:09Z
canonical: "kb.pigment.com/in-function"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.

# IN function

## Description

Checks a List to see if items are part of that List or if items fall within a defined range in that List, then returns a true or false value.

## Syntax

**For specific items**

`List IN (List."Item1", List."Item2",..., List."ItemN")`

When using specific items, or referencing a Metric with one specific item, use a `,` to separate the different values. Must have at least 1 value but can contain multiple different values.

**For ranges**

`List IN (source_block_lower : source_block_upper)`

When using a range, use : to separate the lower value and the upper value (inclusive values). `source_block` can be a List property or Metric that is Date, Number, or Integer formatted.

## Return type

`Boolean` (True or False)

## Examples

| **Case** | **Results** | **Return Type** |
| --- | --- | --- |
| `Country IN (Country."France", Country."UK")` | returns `TRUE `for the 2 countries listed, `FALSE `for the others | `boolean` |
| `NOT Month IN (Month."Jan 22", Month."Feb 22", Month."Mar 22")` | returns `FALSE `for the months listed, `TRUE` for the others | `boolean` |
| `'Switchover date' [Add: Year] IN (Year.'Start Date': Year.'End Date')` | returns `True `for the year that the `Switchover date` is within the range of the `Start Date` and `End Date` of that Year. | `boolean` |

**Excel equivalent**: none

**See also**: [NOT](/v1/docs/not-function)