RANGE_CONTAINS

Check whether a value exists in a range.

Parameter List

Syntax
RANGE_CONTAINS(search_keyrangemode)
search_key

The value you are looking for.

range

The range to be considered in this search.

mode

The comparation mode. By default (0), the function uses an exact match method. Use 1 to check if the search_key is inside any cell of the range.

Examples

RANGE_CONTAINS("John", A1:A3, 0) returns TRUE