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

Sample usage



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

  • index – Which choice (of the up to 29 provided) to be returned.

    • If index is zero, negative or greater than the number of choices provided, the #NUM! error is returned.
  • choice1 – A potential value to be returned. 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 that shifts a specified number of rows and columns from a starting cell reference.


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

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.

Clear search
Close search
Google apps
Main menu