Excel’s CHOOSE Function with Array

The Excel CHOOSE function returns a value/reference from an array using a given position.

Syntax:

=CHOOSE (index_num, value1, [value2], ...)

Arguments:  

• index_num: The value to choose.
• value1: The first value from which to choose.
• value2 [optional]: The second value from which to choose.
• index_num: It is the first argument for CHOOSE function and it refers to the position of an array.

Sample Data: In the Sales Table, we have given Products_Id.  We use Excel CHOOSE() to fill Actual Products Name in the next column (Column – D).

Sales Table

Example 1: Returning a value

Step 1: Type “Products” in cell D1

Step 2: Write a CHOOSE function in cell D2  

=CHOOSE(C2,"Fashion","Electronics","Daily Essentials")

Step 3: Select cell D2 and drag till cell D11

Example 2: Returning a cell reference

Step 1: Type “Products” in cell D1

Step 2: Create a Product table (unique list of Products) in “Column H”  

Step 3: Write a CHOOSE function in cell D2

=CHOOSE(C2, $H$2,$H$3,$H$4)

Step 4: Select cell D2 and drag till cell D11.