CHOOSE

CHOOSE returns the item at a given index from a list of values. It is handy for mapping a number (like 1–7) to a label, or switching between formulas.

Excel

=CHOOSE(2, "North", "South", "East")

Google Sheets

=CHOOSE(2, "North", "South", "East")

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

How it works

1The first argument is the index — here 2.
2The remaining arguments are the options.
3CHOOSE returns the 2nd option, "South".

Need a version for your data?

Try: “Turn the weekday number in A2 into a day name using CHOOSE”

IF IFERROR IFS

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026

CHOOSE

Try it with your data

How it works

Related