ISINARRAY

Returns TRUE if value is found in an array, otherwise FALSE

Syntax:

ISINARRAY(array, value)

array is the array of values we are looking at.

value is the element we are looking for in array.

Example:

If A1:A10 contains numbers 1 to 10, and B1 contains 1:

ISINARRAY(A1:A10, B1)

returns TRUE

If A1:A10 contains numbers 1 to 10, and B1 contains 11:

ISINARRAY(A1:A10, B1)

returns FALSE