=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.

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") |  |