CHOOSE function

CHOOSE uses an index to return a value from a list of up to 30 values.


CHOOSE(index, value 1, value 2, ...)

  • index is a cell reference or number from a list of values indicating which value is to be taken from the list.
  • value 1, value 2, ... are the value entered as a reference to a cell or as individual values.
  • If index is greater than the number of values given, CHOOSE returns #VALUE!.
  • You cannot use CHOOSE to return a range reference. For example, =SUM(A1:CHOOSE(1, A2, A3)) returns #ERROR!.


=CHOOSE(A1, B1, B2, B3, "Today", "Yesterday", "Tomorrow") returns the contents of cell B2 for A1 = 2. For A1 = 4, the function returns the text Today.

=CHOOSE(A1, B1, B2, B3, "Today", "Yesterday", "Tomorrow") returns #VALUE! for A1 = 8.