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.