CHOOSE Function

This article explains how to use CHOOSE function

Sample usage

CHOOSE(2, "Red", "Blue", "Orange")


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.


  • 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.


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:

CHOOSE(2, "Item1", "Item2", "Item3")

In this example, the item chosen is “Item2” because is on the second position as the index_num indicates.