# 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: I**n the Sales Table, we have given Products_Id. We use Excel CHOOSE() to fill Actual Products Name in the next column (Column – D).

**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.