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
