Home › Excel formulas › Lookup and Reference › CHOOSE

CHOOSE Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

CHOOSE is an Excel Lookup & Reference function. Picks one value from a list based on a position number.

CHOOSE syntax

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

Arguments

index_num: Which item to return (1-based position)
value1, value2, ...: The list of items to choose from

When to use CHOOSE

Turning a numeric rating (1–5) into a readable label like Poor, Fair, Good, Great, Excellent.

Practice CHOOSE online, free

Solve graded CHOOSE practice questions in a live Excel-style spreadsheet and check your answer instantly.

Practice CHOOSE now →

Learn more

Read the tutorial: How to use CHOOSE.

More Lookup & Reference functions

Frequently asked questions

What does the CHOOSE function do in Excel?

Picks one value from a list based on a position number.

What is the syntax of CHOOSE in Excel?

The syntax is =CHOOSE(index_num, value1, [value2], ...). index_num: Which item to return (1-based position); value1, value2, ...: The list of items to choose from.

Where can I practice CHOOSE online for free?

Open the free live spreadsheet on Cellgrids and try CHOOSE yourself. No Excel install is needed and you can start without signing up.

All Excel formulas · Cheat sheet · Excel exercises · Lookup and Reference functions · Excel case studies · Excel tutorials · Excel shortcuts