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

1. Microsoft Office Excel 2007 Tutorial
2. Lookup Reference functions
3. CHOOSE

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

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