CHOOSE Function

This article explains how to use the CHOOSE function

Sample usage

FS
CHOOSE(2, "Red", "Blue", "Orange")
FS
CHOOSE(QA, DA_A)

Syntax

FS
CHOOSE (index_num, value1, [value2], ...)
  • index_num - The value to choose. A number.
  • value1 - The first value from which to choose.
  • value2 - [optional] The second value from which to choose.

Notes

  • If index_num is out of range, CHOOSE will return #VALUE
  • Values can also be references. For example, QA, or DA_A can be supplied as values.

Examples

This function returns a value from a list using a given position or index. The values provided to CHOOSE can include references.

Let’s say you have to pick an “Item” from a list.

The function is:

FS
CHOOSE(2, "Item1", "Item2", "Item3")
In this example, the item chosen is “Item2” because is on the second position as the index_num indicates.

Related articles

Learn more about choose in one of the following articles