How to Use CHOOSE Function | Microsoft Excel

How to Use CHOOSE Function | Microsoft Excel

how to use choose function

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


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

how to use 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
Index number is less than 1 or greater than last value 

More Examples

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.

how to use choose function


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


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.

Leave a Reply

Your email address will not be published. Required fields are marked *