CHOOSE

Definition: CHOOSE is a function that returns a value from a list of values based on a specified index.

Syntax: =CHOOSE(index_num, value1, [value2], …)

Situation: This formula is suitable when you need to return a value from a list of values based on an index, such as returning the name of a month based on its number.

Example: If you have a list of months in cells A1:A12 and want to return the name of the month based on its number in cell B1, you can use the formula =CHOOSE(B1, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12), which returns the name of the month.