How to use CHOOSE function in Excel 2013

Excel's Lookup functions like VLOOKUP, HLOOKUP, CHOOSE, INDEX, MATCH etc. are used to find and return data from a list or table based on a lookup value or index number.

In CHOOSE function, it uses an index number to find and return a specific value from a corresponding list of data. The index number indicates the position of the value in the list.

Syntax:     CHOOSE(index_num, value1, [value2], [value3]....[value254])

• index_num: Specifies the Value is to be returned by the function. It could be a number or formula or a cell reference. The value for this should be betweent 1 and 254.
• value1: The value/data we want to fetch when "index_num" equals 1
• value2: The value/data we want to fetch when "index_num" equals 2

The value/data for output { value1, value2, .....etc.} could be numbers, cell references, defined names, formulas, functions, or text.

IMPORTANT NOTES:

• If index_num < 1 OR if index_num > "number of values" then Excel gives #VALUE! error
• If index_num is a fraction, it is changed to the lowest integer before being used (eg. 3.8 to 3)
• If index_num is an array, every value is evaluated when CHOOSE is evaluated