### 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 INDEX function when you have more than 255 values.* You can use the MATCH function to return the position of a value.* For the Microsoft documentation refer to support.microsoft.com

 A B 1 =CHOOSE(2,"1st","2nd","3rd","Finished") = 2nd 3 2 =CHOOSE(B1,"Nails","Screws","Nuts","Bolts") = Nuts 2 3 =CHOOSE(B2,"Nails","Screws","Nuts","Bolts") = Screws 12 4 =CHOOSE(2.5,"Nails","Screws","Nuts","Bolts") = Screws 5 =CHOOSE(B2,"First","Second","Third") = Second 6 =CHOOSE(5,"Mon","Tue","Wed","Thu","Fri","Sat","Sun") = Fri 7 =CHOOSE({3,4},"Mon","Tue","Wed","Thu","Fri","Sat","Sun") = Wed 8 =CHOOSE({4,3},"Mon","Tue","Wed","Thu","Fri","Sat","Sun") = Thu 9 =CHOOSE(2,"1st",named_range,"2nd","3rd","4th") = 12 10 =CHOOSE(-1,"Nails","Screws","Nuts","Bolts") = #VALUE! 11 =CHOOSE(5,"1st","2nd","3rd","4th") = #VALUE! 12 =CHOOSE(2,{1,2,3,4}) = #VALUE! 13 =SUM(CHOOSE(2,B1,B1:B2,B1:B3)) = 5

 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.