What is the CHOOSE Function in MS Excel?

This function is used to return the value from the values in the arguments. This is the type of function in Excel that is not very useful on its own but it has many benefits when combined with other functions.  

Purpose of the CHOOSE Function in MS Excel

The purpose of the CHOOSE function in Excel is to get the value from a specific list by specifically mentioning the position of the value in the list. However, this function has many advanced uses as well that are worth exploring.

Syntax of the CHOOSE Function

The syntax of the CHOOSE function in MS Excel is written as below.

CHOOSE (index_num, value1, [value2], …)

Arguments

The arguments in the CHOOSE function are described below.

Index_num: this is the position of the value which you want to be returned. It can be a cell reference, some formula, or a number between 1 and 254.

Value 1, value 2, …: this is the list of 254 values. You can choose any value between 1 and 254. Value 1 is a must, other values are optional. Other values can be text, numbers, logical values, etc.

Examples

=CHOOSE (2, A2, A3, A4, A5)

In this example, 2 is the index number from where you have to choose the value to be returned. A2, A3, A4, and A5 are the values.