# Excel CHOOSE Function

The Excel CHOOSE function returns a value from a list using a given position or index. For example, CHOOSE(2,"red","blue","green") returns "blue", since blue is the 2nd value listed after the index number. The values provided to CHOOSE can include references.

**index_num**- The value to choose. A number between 1 and 254.**value1**- The first value from which to choose.**value2**- [optional] The second value from which to choose.

Choose can handle up to 254 values. **Index_num** returns a value based on it's position in the list. For example, if **index_num** is 2, **value2** is returned.

Values can also be references. For example, the address A1, or the ranges A1:10 or B2:B15 can be supplied as values.

## Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.