CHOOSE formula in Excel with examples

The CHOOSE function in Excel is quite versatile. It allows you to retrieve a value from a list based on a specified position. Let’s explore its syntax and some practical examples:

1. Syntax:

   • The CHOOSE function has the following structure:

     =CHOOSE(index_num, value1, [value2], ...)
     

   • index_num (required): Specifies the position of the value to return. It can be any number between 1 and 254, a cell reference, or another formula.
   • value1, value2, …: A list of up to 254 values from which to choose. value1 is required, while other values are optional. These can be numbers, text values, cell references, formulas, or defined names.

2. Example:

   • Let’s say we have the following list: “Mike,” “Sally,” “Amy,” and “Neal.”

     =CHOOSE(3, "Mike", "Sally", "Amy", "Neal")
     

     The formula returns “Amy” because index_num is 3, and “Amy” is the 3rd value in the list.

3. Advanced Uses:

   • Alternative to Nested IFs: Instead of using nested IF statements, the CHOOSE function can simplify your logic.
   • Random Data Generation: Combine CHOOSE with RANDBETWEEN to generate random data.
   • Left Lookup: Use VLOOKUP and CHOOSE for left lookups.
   • Get Day/Month Names from Dates: Extract day or month names using CHOOSE.

Remember, the CHOOSE function is a powerful tool for customizing your Excel calculations!