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.