Excel Function

CHOOSE

Returns a value from a list by index.

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

Arguments

index_num

Required

Enter a numeric value.

value1

Required

Enter a text value (wrap with quotes when needed).

value2

Optional

Enter a text value (wrap with quotes when needed).

Practice Preview

Use CHOOSE to return the 2nd option (1: "High", 2: "Low").

Example Table

#	ALearner ID	BName	CScore
2	U001	Tanaka	82
3	U002	Sato	67
4	U003	Suzuki	91
5	U004	Takahashi	55
6	U005	Ito	78
7
8

How to Use (Formula)

=CHOOSE(2, "High", "Low")

Result

Low

Practice This Function

Start Function Practice Back to Function List

CHOOSE FAQ

How do I use CHOOSE in Excel?

Use CHOOSE when you want to pick a value by index number. Enter Index number, Value 1, Value 2 in that order, then add optional arguments when needed.

Where can I practice CHOOSE?

Use the "Start Function Practice" button to jump straight into CHOOSE drills.

What arguments does CHOOSE use?

The main arguments are Index number, Value 1, Value 2. Start with the required ones, then add optional arguments if needed.