Excel CHOOSE function – Syntax
Based on a defined location, Excel’s CHOOSE function is intended to return a value from the list.
Syntax:
=CHOOSE(index_num, value1, [value2], ...)
Parameter:
- Index_num: The value we want to choose. The number must be between 1 and 254.
- Value1: The first value from which to choose.
- Value2 (Optional): The second value from which to choose.
Excel CHOOSE function – things to remember
The CHOOSE function is fairly simple, so adding it to your worksheets shouldn’t be too tough. The following factors may be to blame if the result your CHOOSE formula returns is unexpected or not the one you were seeking:
- There are only 254 possible values to select from.
- The #VALUE! Error is returned if index num is less than 1 or more than the number of values in the list.
- If the index num parameter is a fraction, the lowest integer is used instead.
How to use CHOOSE Function in Excel
The CHOOSE function is technically part of Excel’s lookup function and can be incredibly useful. The CHOOSE function returns a value from a list using an index. One of those Excel features, CHOOSE, may not seem helpful alone, but when paired with other functions, it offers a ton of fantastic advantages.
In most basic form, the CHOOSE function allows you to select a value from a list by its position. Here we’ll see what the Excel CHOOSE Function is all about.
Contact Us