Formulas and Functions
Modifying this control will update this page automatically

CHOOSE

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.

Tip: To choose from a range of cells rather than a list of values, use the INDEX function.

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.

Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.