CHOOSE
Description
Returns a value from a list of values, based on a specified index number.
Syntax
CHOOSE(
index_num
,
value1
, ...)
- index_num: The index of the item to return. If index_num = 1, the function returns the first value. You can use a cell reference as the index value.
- value1: A list of values, or references to cells containing values. The values can be formula expressions.
Example
Formula | Result |
|---|---|
=CHOOSE(A1,B1,B2,B3,B4) where A1 contains 3 and B3 contains
30. | 30 |