CHOOSE

Get a value from a list based on position

Sponsored Link

CHOOSE

Purpose 

Get a value from a list based on position

Return value 

The value at the given position.

Syntax 

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

Arguments 

  • index_num - The value to choose. A number between 1 and 254.
  • value1 - The first value from which to choose.
  • value2 - [optional] The second value from which to choose.

Usage notes 

Choose can handle up to 254 values. Index_num returns a value based on it's position in the list. For example, if index_num is 2, value2 is returned.

Values can also be references. For example, the address A1, or the ranges A1:10 or B2:B15 can be supplied as values.

Sponsored Link

0 votes. 0 / 5