The Excel CHOOSE function uses an index number to find and return a specific value from its list of data. The index number indicates the position of the value in the list.
Remark † The information in this article applies to Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2019 for Mac, Excel 2016 for Mac, Excel for Mac 2011, and Excel Online.
 SELECT Features overview
 CHOOSE Function Syntax and Arguments
 An example of using the CHOOSE function in Excel to find data
 Enter training data
 Enter the SELECT function
 Calculate employee bonus
 Copy employee bonus formula with fountain pen
SELECT Features overview
Like many Excel functions, CHOOSE is most effective when combined with other formulas or functions to return different results.
An example would be to use CHOOSE to perform calculations with the Excel functions SUM, AVERAGE, or MAX on the same data, depending on the index number selected.
CHOOSE Function Syntax and Arguments
Function syntax refers to the layout of the function and includes the function name, parentheses, and arguments.
The syntax for the CHOOSE function is:
= CHOOSE ( index number † Value1 † value2 † Value254 †
Index_num (necessary). Determines what value to return by the function. Index_num can be a number from 1 to 254, a formula, or a cell reference containing a number from 1 to 254.
Meaning (requires value 1. Additional values up to a maximum of 254 are optional): A list of values returned by the function, depending on the Index_num argument. Values can be numbers, cell references, named ranges, formulas, functions, or text.
An example of using the CHOOSE function in Excel to find data
Follow the example in this guide to illustrate how to use the CHOOSE function. In our example, we use the SELECT function to calculate the annual employee bonus.
The bonus is a percentage of their annual salary and this percentage is based on a performance score of 1 to 4.
The CHOOSE function converts the performance rating to the appropriate percentage:
Рейтинг 1: 3%
Рейтинг 2: 5%
Рейтинг 3: 7%
Рейтинг 4: 10%
This percentage is then multiplied by the annual salary to find the employee’s annual bonus.
The example shows how to enter the CHOOSE function in cell G2, and then use the fill handle to copy the function to cells G2G5.
Enter training data
Enter the following information in cells D1 to G1:

Cell D1: Employee

Cell D2: J. Smith

Cell D3: C. Jones

Cell D4: R. Johnston

Cell D5: L. Rogers

Cell E1: Assessment

Cell E2: 3

Cell E3: 4

Cell E4: 3

Cell E5: 2

Cell F1: Salary

Cell F2: $50,000

Cell F3: $65,000

Cell F4: $70,000

Cell F5: $45,000

Cell G1: Bonus
Enter the SELECT function
This section of the tutorial introduces the CHOOSE function in cell G2 and calculates the bonus percentage based on the performance rating for the first employee. These steps apply to Excel 2019, Excel 2016, Excel 2013, Excel 2010, and Excel for Mac.

Select cell G2 † Displays the results of the function.

Select tab formulas †

Select Search and help to open the dropdown list of functions.

Select CHOOSE in the list to open the Function Arguments dialog box.

Place the cursor on the line Index_num in the dialog box.

Select cell E2 on the sheet to enter a cell reference in the dialog box.

Place the cursor on the line Value1 in the dialog box.

Enter 3% in this line.

Place the cursor on the line value2 in the dialog box.

Enter five% in this line.

Place the cursor on the line Value3 in the dialog box.

Enter 7% in this line.

Place the cursor on the line Value4 in the dialog box.

Enter 10% in this line.

Click Okay to end the function and close the dialog box.
The value 0.07 appears in cell G2, the decimal form for 7%.
Excel Online does not have a Formula tab. Instead, use the Insert Function button to enter the SELECT function in Excel Online or another version of Excel.

Select cell G2 † Displays the results of the function.

Select Insert function next to the formula bar.

Select Search and help in the category list.

Select CHOOSE in the list and select Okay †

Enter (E2.3%, 5%, 7%, 10%) after = CHOOSE in the formula bar. Don’t forget to put parentheses.

Click Enter †
The value 0.07 appears in cell G2, the decimal form for 7%.
Calculate employee bonus
You can now modify the SELECT function in cell G2 by multiplying the function’s results by the employee’s annual salary to calculate their annual bonus.
This change is done using the F2 key to edit the formula.

Select cell G2 to make it active.

Click F2 to put Excel in edit mode. Full function
=SELECT(E2.3%, 5%, 7%, 10%) appears in a cell with an insertion point after the closing parenthesis of the function. 
Enter an asterisk ( † ), the multiplication symbol in Excel, after the closing parenthesis.

Select cell F2 on the worksheet to enter the cell reference to the employee’s annual salary in the cell.

Click Enter to end the formula and exit edit mode.

Cell G2 contains $3,500.00, which is 7% of the employee’s annual salary of $50,000.00.

Select cell G2. † The full formula = CHOOSE(E2.3%, 5%, 7%, 10%) * F2 is displayed in the formula bar above the worksheet.
Copy employee bonus formula with fountain pen
The last step is to copy the formula in cell G2 to cells G3G5 using the fill handle.

Select cell G2 to make it active.

Place your mouse pointer over the black square in the lower right corner of cell G2. The pointer changes to a plus sign (+).

Drag the fill handle to a cell G5.

Cells G3G5 contain bonus numbers for the other employees.