CHOOSE Function is used to get one indexed value from the list of the values.
For example, there are 7 days Monday, Tuesday, Wednesday, Thursday, Friday, Saturday and Sunday and  the days have arranged in sequence 1 to 7. 1=Monday, 2=Tuesday... and so on
You have to use CHOOSE Function to get the value. If you use 2 number then CHOOSE Function will return the second day(Tuesday) from the list,  If you use 5 number then CHOOSE will return the fifth day(Friday) from the list.

### Syntax of CHOOSE Function

=CHOOSE(index_num,value1,[value2]...)

### Argument For Choose Function

index_number: it is a number of the index value to return data from the list. Index number should be in between 1 to 254
value1,[value2]...: it can be a list, reference, and any data

### Behavior of CHOOSE Function

For Example,
You have four month names January, February, March, and April are in a sequence of 1 to 4.
You are using the function
=CHOOSE(3, C4,C5,C6,C7)
Here 3 is the index number which indicates the value on the 3 rd number must be returned from the list.
For this, the CHOOSE function will return the value located on cell number C6, Which is March.

### Return of CHOOSE Function

CHOOSE Function will return the data of the index value from the list

### Usage of CHOOSE Function

CHOOSE Function is used to get a single value from the list by giving an index number

### Error Values For CHOOSE Function

Error CommandsDescription
#VALUE
 Index number is less than 1 or greater than last value

### Example 1 Giving an opinion from 1 to 5 as 1 For Excellent, 2 For Good, 3 For Average, 4 For Poor, 5 For Disgusting.

Here you have five values and five data.

### Values

You have to write five values and data in a column as shown in the figure. here data and values are placed as per above description. 1 For5 Excellent .... 5 For Disgusting

### Returns

Choose function will return the opinion as per the numbering from 1 to 5.
CHOOSE function fetches the number in cell E4 and return the value assigned to the reference data which is cell number C5 is AVERAGE.
This is the same for number 1 to 5 where 5 will return Disgusting.
_________________________________________________________________________
How would you like this content to write us in the comment box!
If you face any difficulty in the content feel free to ask!
Thank You.