CHOOSE(index_num, value1 [,value2] [..]) 
Returns the value in a row (or column) based on an index number. 
index_num  The position you want to return. 
value1  The first value. 
value2  (Optional) The second value. 
Remarks 
* This function can return an array. * The "index_num" can be between 1 and 29 that specifies which value to choose. * If "index_num" = 1 then "value1" is returned. * If "index_num" = 2 then "value2" is returned, and so on. * If "index_num" < 1, then #VALUE! is returned. * If "index_num" > the number of arguments, then #VALUE! is returned. * If "index_num" is a fraction, it is truncated to the lowest integer before being used. * If "index_num" is an array, every value is evaluated. * The "index_num" can be a formula or reference to a cell containing a number between 1 and 29. * The "value" arguments can be numbers, cell references, named ranges, formulas, functions or text. * You can have a maximum of 255 arguments. * You can use the MATCH function to return the position of a value. * For the Microsoft documentation refer to support.office.com 

1  What is the 2nd item in the given list. 2  What is the 3rd item in the given list. 3  What is the 2nd item in the given list. 4  What value is returned when the index number is 2.5. 5  What is the 2nd item in the given list. 6  What is the 5th item in the given list. 7  What value is returned when you pass an array as the index number. 8  What value is returned when you pass an array as the index number. 9  This function can return values from cells with named ranges. 10  What if the index number is less than one. 11  What if the index number is greater than the number of arguments. 12  What if the second argument is a list. 13  This function can return an array of values. In this example the function returns the array {3,2} which is then passed to the SUM function. 
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top