The CHOOSE function returns a value from a collection of values based on a specified index value.
CHOOSE(index, value, value…)
index: A number value representing the index of the value to be returned. index must be greater than 0.
value: Any value. value can contain only a single value.
value…: Optionally include one or more additional single values.
Examples |
|---|
Assume that cell A3 contains 3. =CHOOSE(4,“Monday”, “Tuesday”, “Wednesday”, “Thursday”, “Friday”, “Saturday”, “Sunday”) returns Thursday, the fourth value in the list. =CHOOSE(A3, “1st”, “second”, 7, “last”) returns 7, the third value in the list. |