How to Use CHOOSE Function in Excel: Simple Guide

The CHOOSE function in Excel returns a value from a list based on a given position number. You provide an index number and a list of values, and CHOOSE picks the value at that position.

Syntax

The syntax of the CHOOSE function is simple:

• index_num: The position number of the value you want to select (must be a number between 1 and the number of values).
• value1, value2, ...: The list of values to choose from.

The function returns the value at the position index_num in the list.

excel

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

Example

This example shows how to use CHOOSE to pick a day name based on a number:

excel

=CHOOSE(3, "Monday", "Tuesday", "Wednesday", "Thursday", "Friday")

Output

Wednesday

Common Pitfalls

Common mistakes when using CHOOSE include:

• Using an index_num that is less than 1 or greater than the number of values, which causes an error.
• Forgetting that index_num must be a number, not text.
• Providing too few values for the index number requested.

Example of wrong and right usage:

excel

=CHOOSE(0, "Apple", "Banana")  
=CHOOSE(2, "Apple", "Banana")

Output

#VALUE!  
Banana

Quick Reference

Part	Description
index_num	Position number to select (1-based)
value1, value2, ...	List of values to choose from
Return	Value at the position index_num

Key Takeaways

Use CHOOSE to select a value from a list based on a position number.

The index number must be between 1 and the number of values provided.

If the index number is out of range, CHOOSE returns an error.

CHOOSE works well for simple selection tasks without complex lookup tables.