CHOOSE

Returns a value based on an index.

Indexing means the position of an item in a list. If for example, you have a list with the values 1,3,5,7,13, the item at position three has the value five.

CHOOSE requires at least two arguments. The first argument represents the index of the value that the corresponding item is selected from.

Input: CHOOSE(Position of the item, Item1..Item2)

Example

CHOOSE(1;2;4;6;8;19) returns 2

CHOOSE(3;2;4;6;8;19) returns 6