Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Lookup and Reference > CHOOSE
 

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

 
 Returns the value from a list of values, based on an index number.

 index_numThe index number.
 value1The first value.
 value2The second optional 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.

     EXAMPLES
     
     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=SUM(CHOOSE(2,C1,C1:C2,C1:C3)) = 5  
    		 
     Functions - C | Index - C | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top