INDEXOF

Syntax

INDEXOF(<list>;<element any>)

Returns (as an integer) the index of the first occurence of an element in a list counting from zero (0) or -1 if the element isn't found.

Column1	Searching for element	INDEXOF returns
[1, 2, 3, 4, 5]	4	3
[apple, banana, peach, orange, kiwi]	peach	2
[11, 12, 13, 14, 15]	17	-1