INDEXOF

Syntax

INDEXOF(<list>;<element any>)

Description

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.

Examples

Column1Searching for elementINDEXOF returns
[1, 2, 3, 4, 5]43
[apple, banana, peach, orange, kiwi]peach2
[11, 12, 13, 14, 15]17-1