The CHOOSE function in Excel allows you to select an item from a list based on its position. It’s like choosing from a menu where you pick an item by its number.
Syntax
CHOOSE(index_num, value1, [value2], …)
Arguments
| index_num: | The position of the value you want to choose. It should be a number between 1 and 254. |
| value1: | The first value or item you want to choose from. |
| [value2]: | (Optional) The second value or item you want to choose from. You can include up to 253 more optional values. |
How to use
You can use the CHOOSE function to select an item from a list of values. Here’s how you can use it with some examples: Example 1: Selecting a Fruit
|
1 |
=CHOOSE(2, "Apple", "Banana", "Cherry", "Date") |
This formula will return “Banana” because it selects the second item in the list. Example 2: Choosing a Day of the Week
|
1 |
=CHOOSE(4, "Monday", "Tuesday", "Wednesday", "Thursday", "Friday") |
In this case, the formula will return “Thursday” as it picks the fourth day. You can use this function in various scenarios, like creating dynamic drop-down lists or making choices based on specific conditions.