CHOOSE(index_num, value1 [,value2] [..])

Returns the value in a row (or column) based on an index number.

index_numThe position you want to return.
value1The first value.
value2(Optional) The second value.

Remarks

* 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 29 arguments.
* You can use the MATCH function to return the position of a value.
* For the Microsoft documentation refer to support.office.com

 ABC
1=CHOOSE(2,"1st","2nd","3rd","Finished") = 2nd 3
2=CHOOSE(C1,"Nails","Screws","Nuts","Bolts") = Nuts 2
3=CHOOSE(C2,"Nails","Screws","Nuts","Bolts") = Screws 12
4=CHOOSE(2.5,"Nails","Screws","Nuts","Bolts") = Screws  
5=CHOOSE(C2,"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,C1,C1:C2,C1:C3)) = 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.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top