=CHOOSE(4,B2,B3,B4,B5) : CHOOSE « Lookup Reference functions « Microsoft Office Excel 2007 Tutorial
- Microsoft Office Excel 2007 Tutorial
- Lookup Reference functions
- CHOOSE
Input the formula: =CHOOSE(4,B2,B3,B4,B5). Press Enter to get the result.
![Input the formula: =CHOOSE(4,B2,B3,B4,B5)](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/choose4b2b3b4b5___Input_Formula_choose4b2b3b4b5.PNG)
19.3.CHOOSE |
| 19.3.1. | CHOOSE(index_num,value1,value2,...) chooses a value from a list of values | ![CHOOSE(index_num,value1,value2,...) chooses a value from a list of values](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/Chooseindex_numvalue1value2_Chooses_Value_From_L___Input_Formula_choose2a2a3a4a5.PNG) |
| 19.3.2. | =CHOOSE(4,B2,B3,B4,B5) | ![=CHOOSE(4,B2,B3,B4,B5)](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/choose4b2b3b4b5___Input_Formula_choose4b2b3b4b5.PNG) |
| 19.3.3. | =SUM(CHOOSE(2,B1:B3,C1:C3)) | ![=SUM(CHOOSE(2,B1:B3,C1:C3))](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/sumchoose2b1b3c1c3___Input_Formula_sumchoose2b1b3c1c3.PNG) |
| 19.3.4. | =CHOOSE(2, "One", "Two", "Three"). | ![=CHOOSE(2,](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/choose2_one_two_three___Input_Formula_choose2_one_two_three.PNG) |
| 19.3.5. | =CHOOSE(A1,"January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December") | ![=CHOOSE(A1,](http://www.java2s.com/Tutorial/Microsoft-Office-Excel-2007Images/choosea1january_february_march_april_may____Input_Formula_choosea1january_febru.PNG) |