=Choose(index_num, value1, value2, . . . )
Choose uses index_num to return a value from a list of values.
If index_num is 1, CHOOSE will return value1, etc.
index_num can be a number, a formula that results in a number, or a reference to a cell.
index_num must refer to a number between 1 and 29, or the maximum number of values.
Up to 29 values can be listed.
Values can be numbers, text, cell references, formulas, functions or defined names
=CHOOSE(3, North, South, East, West)
A | B | C | D | E | F | G | |
---|---|---|---|---|---|---|---|
1 | Weekday |
3 |
|||||
2 | |||||||
3 | =CHOOSE(B1, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday) |
||||||
4 | |||||||
5 | |||||||
6 |
The sample above shows a number in the cell B1.
This number represents a day of the week.
We want to convert this number to the name of the day.
The CHOOSE function in cell A3 will return the name from the list of values.
The index_num is B1, which evaluates to the number 3.
The third value in the list is Tuesday.
The result will look like the following sample.
A | B | C | D | E | F | G | |
---|---|---|---|---|---|---|---|
1 | Weekday |
3 |
|||||
2 | |||||||
3 | Tuesday |
||||||
4 | |||||||
5 | |||||||
6 |
CHOOSE can also use cell references in the values list.
In this example, the names of the regions are in the range of B2:B5.
The value in F2 is the region number we want.
A | B | C | D | E | F | G | |
---|---|---|---|---|---|---|---|
1 |
Regions |
2 |
|||||
2 | East |
||||||
3 | West |
||||||
4 | South |
||||||
5 | North |
||||||
6 |
=CHOOSE(F1, B2,B3,B4,B5)