Excel CHOOSE Function

What is CHOOSE function in Excel ?

The CHOOSE function is one of the Lookup & reference functions of Excel.

It Chooses a value or action to perform from a list of values, based on an index number.

We can find this function in Lookup & reference category of insert function Tab.

How to use CHOOSE function in excel

  1. Click on an empty cell (like F5 ).
an empty cell in excel

2. Click on the fx icon (or press shift+F3).

 the fx icon in excel

3. In the insert function tab you will see all functions.

insert function tab in excel

4. Select Lookup & reference category.

5. Select CHOOSE function.

6. Then select ok.

excel CHOOSE function

7. In the function arguments Tab, you will see CHOOSE function.

8. Index num section specifies which value argument is selected.

Index num must be between 1 and 254, or a formula or a reference to a number between 1 and 254.

9. Value1: value1,value2,… are 1 to 254 numbers, cell references, defined names, formulas, functions, or text arguments from which CHOOSE selects.

10. You will see the result in the formula result section

How to use CHOOSE function in excel

Examples of CHOOSE function in excel

Examples of CHOOSE function in excel

CHOOSE related functions 

Leave a Reply

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