CHOOSE function

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.


CHOOSE(index_num, value1, [value2], …)


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

This formula will return “Banana” because it selects the second item in the list. Example 2: Choosing a Day of the Week

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.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.