Choose function

Description

This CHOOSE function return a value from a list using a given position or index. For example, CHOOSE(2,"red","blue","green") return "blue", since is the 2nd value listed after the index number. The value provided to CHOOSE can include reference.

​

Objective

Obtain a value from a list base on position.

​

Syntax

=CHOOSE(index_num,value1,[value2],...)

​

Arguements

index_num - Value to choose. A number between 1 and 254.

value1 - First value from which to choose.

value2 - [optional] second value from which to choose.

​