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
- Click on an empty cell (like F5 ).

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

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

4. Select Lookup & reference category.
5. Select CHOOSE function.
6. Then select ok.

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

Examples of CHOOSE function in excel

CHOOSE related functions
- IF function
- MATCH function
- SWITCH function
- VLOOKUP function