Examples on How to Use CHOOSE Function in Excel
Let’s consider the following 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: Enter the Formula
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 we 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: Enter SUM(CHOOSE(H3))
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: Enter “=SUM(CHOOSE(H3,B4:B9,C4:C9,D4:D9,E4:E9))”
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: Press Enter
Then we press ENTER on our keyboard. This will return the sum of values for 1 which is Jan.
How to use CHOOSE Function in Excel
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. One of those Excel features, CHOOSE, may not seem helpful alone, but when paired with other functions, it offers a ton of fantastic advantages.
In most basic form, the CHOOSE function allows you to select a value from a list by its position. Here we’ll see what the Excel CHOOSE Function is all about.
Contact Us