Syntax
CHOOSE(index_num, value1, [value2], ...)- index_num
- Which value to return, from 1.
- value1
- The first value.
- value2 (optional)
- More values, up to 254.
Examples
B1
=CHOOSE(12,2"Small",3"Medium",4"Large")| A | B | |
|---|---|---|
| 1 | Medium |
In plain words: Take 1item number 2 from the list 2Small, 3Medium, 4Large.
B1=CHOOSE(3,10,20,30)
| A | B | |
|---|---|---|
| 1 | 30 |