CHOOSE

Returns an element from a list of choices based on index.

Sample Usage

CHOOSE(2,"A","B","C")

Syntax

CHOOSE(index, choice1, [choice2, ...])

  • index - Which choice (of the up to 29 provided) to return.

    • If index is zero, negative, or greater than the number of choices provided, the #NUM! error is returned.
  • choice1 - A potential value to return. Required. May be a reference to a cell or an individual value.

  • choice2, ... - Additional values among which to choose.

See Also

OFFSET: Returns a range reference shifted a specified number of rows and columns from a starting cell reference.

Examples

Uses an index to return a value from the specified list of up to 30 values.

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu