INDEX

Extract the value in the list at the given position

Usage

INDEX(list, position)

Parameters

list

(Required) The list to extract from

position

(Required) The position of the value to extract. The first position is 1

Examples

Example With these variables Result

INDEX([“CAD”, “USD”], 2)

(None)

“USD”

INDEX([“CAD”, “USD”], currencies_pos)

currencies_pos is 3

NOTHING

More information

The [ and ] mark the beginning and end of a list.

If position is greater than the size of the list, then the result is NOTHING.