The following examples show how CHOOSE can extend the capabilities of other Excel functions and provide alternative solutions to some common tasks, even to those that are considered unfeasible by many.

How to use CHOOSE function in Excel - formula examples If the index_num argument is a fraction, it is truncated to the lowest integer.If index_num is less than 1 or greater than the number of values in the list, the #VALUE! error is returned.The number of values to choose from is limited to 254.If the result returned by your CHOOSE formula is unexpected or not the result you were looking for, it may be because of the following reasons: The formula returns 'Amy' because index_num is 3 and 'Amy' is the 3 rd value in the list:Įxcel CHOOSE function - 3 things to remember!ĬHOOSE is a very plain function and you will hardly run into any difficulties implementing it in your worksheets. Here's an example of a CHOOSE formula in the simplest form: These can be numbers, text values, cell references, formulas, or defined names. Value1 is required, other values are optional. Value1, value2, … - a list of up to 254 values from which to choose. It can be any number between 1 and 254, a cell reference, or another formula. Index_num (required) - the position of the value to return.

The syntax of the CHOOSE function is as follows: The function is available in Excel 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010, and Excel 2007. The CHOOSE function in Excel is designed to return a value from the list based on a specified position. CHOOSE formula to get a day/month name from dateĮxcel CHOOSE function - syntax and basic uses.CHOOSE formula to return next working day.VLOOKUP/CHOOSE formula to do a left lookup.CHOOSE/RANDBETWEEN to generate random data.How to use CHOOSE function in Excel - formula examples.Excel CHOOSE function - syntax and basic uses.Further on in this tutorial, you will find several advanced uses that are certainly worth exploring. At the most basic level, you use the CHOOSE function to get a value from a list by specifying the position of that value.

The tutorial explains the syntax and basic uses of the CHOOSE function and provides a few non-trivial examples showing how to use a CHOOSE formula in Excel.ĬHOOSE is one of those Excel functions that may not look useful on their own, but combined with other functions give a number of awesome benefits.

Gibson serial number