Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

CHOOSE

Returns a specific position from a list in Excel
Chooses a value from a list of values

Rational

Returns data based on its position of list.

Description

The Excel CHOOSE function returns a specific cell information from the list of data points based on the given arguments.
For example, =CHOOSE(4,”Railways”,”Roads”,”Airways”,”Waterways”) returns Waterways (4th in the list). The function enables to select a value from a list based on its Index number.

Syntax

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

Parameters

index_num – Specify index number of a list
value 1 – first value of the list
value 2… [optional]– second value of the list and so on.

Return Value

Value of a specific position (index_num) from a list

Key Notes

  • The CHOOSE function is ideal for converting a value to a literal.
  • The CHOOSE function can include a maximum number of 254 arguments or reference cell in the index_num parameter.
  • If the index_num is less than 1 or more than count of strings in the reference list, the formula returns #VALUE! error.