CHOOSE (Index-num, Value 1, value 2, value 3, .)
Index_num
The index-num function sets the return values. Return values are a number between 1 and 29, or a formula or reference in a cell that contains a number from 1 to 29
- If index-num is 1, Choose function returns value 1, if two functions return value 2, .
- If index-num is less than 1 or greater than the last value in the list, the Choose function returns the error value of #VALUE!
- If index-num is a fraction, it will remove the lowest integer part before giving the result
Value1, Value2, Value3 .
A set of values from the returned result
The example uses the CHOOSE function in Excel
- Click on the cell where you want to return the function result
- From the Insert menu, click Function . , Insert Function dialog box is displayed
- From the Insert Function dialog box, click the arrow pointing down from the Or select a category section , select the Lookup & Reference option .
- In the Select a function section , select CHOOSE and click OK . Display the CHOOSE dialog box
- Enter a cell reference or a value into Index_num. In the case above example, enter 3
- Press Tab and enter the first value in Value1 . Enter 'Monday'
- Press Tab and enter the second value in Value2 . Enter 'Tuesday'
- Repeat the above steps until the end (as the example above is from Monday to Sunday).
- Click OK when done. You will see results displayed on the 4th day
Note : If we enter the Index_num item 5, the result is returned to 6th