Skip to content
Related Articles

Related Articles

CHOOSE Function in Excel

Improve Article
Save Article
  • Last Updated : 11 Aug, 2021
Improve Article
Save Article

The CHOOSE function is technically part of Excel’s lookup function and can be incredibly useful. The CHOOSE function returns a value from a list using an index.


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


  • Index_num: The value we want to choose. The number must be between 1 and 254.
  • Value1: The first value from which to choose.
  • Value2 (Optional): The second value from which to choose.

Let’s begin with the examples.

Example 1: To get our Value, follow the below steps:

Step 1: Format your data.

Now, if we want to get the value of any number (index) in E1. Let us follow the next step

Step 2: We will enter =CHOOSE(E1,B3,B4,B5,B6,B7,B8,B9) in E2 cell.

Here we said Excel should return our index (E1) from our list; B3,B4,B5,B6,B7,B8,B9.

This will return a #value! error because there is no number provided in E1.

Let’s put 1 in E1. The CHOOSE function returns Apple because Apple is the value with index 1 on your list.

Example 2: Here I want to pick a month and we want it to display the sum of revenue for that month picked.

 Step 1: Format your data.

Now, if we want to get the sum of the month picked in H4. Let us follow the next step

Step 2: In H3, we would put a number 1, 2, or 3 which represents Jan, Feb, and March. Thus We will enter =SUM(CHOOSE(H3

Step 3: This will be followed by the values in each month. Thus This will be We will enter =SUM(CHOOSE(H3,B4:B9,C4:C9,D4:D9,E4:E9)) in H4 cell.

Step 4: then we press ENTER on our keyboard. This will return the sum of values for 1 which is Jan.

My Personal Notes arrow_drop_up
Related Articles

Start Your Coding Journey Now!