=CHOOSE(4,B2,B3,B4,B5) : CHOOSE « Lookup Reference functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =CHOOSE(4,B2,B3,B4,B5). Press Enter to get the result.
Input the formula: =CHOOSE(4,B2,B3,B4,B5)








19.3.CHOOSE
19.3.1.CHOOSE(index_num,value1,value2,...) chooses a value from a list of valuesCHOOSE(index_num,value1,value2,...) chooses a value from a list of values
19.3.2.=CHOOSE(4,B2,B3,B4,B5)=CHOOSE(4,B2,B3,B4,B5)
19.3.3.=SUM(CHOOSE(2,B1:B3,C1:C3))=SUM(CHOOSE(2,B1:B3,C1:C3))
19.3.4.=CHOOSE(2, "One", "Two", "Three").=CHOOSE(2,
19.3.5.=CHOOSE(A1,"January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December")=CHOOSE(A1,