Lookup & reference · selection · Nov 2026

The CHOOSE function,
measured & explained.

A measured CHOOSE gallery: positional picks, computed indices and CHOOSE→INDEX, every value engine-verified. Live, editable, free.

D1
fx
=CHOOSE(2, "Apple", "Banana", "Cherry")
0
measured gallery rows
0
sourced errors fixed
0
platforms checked
// 01 — Anatomy

How CHOOSE works

1-based selection. Out-of-range index → #VALUE! (Excel) / #NUM! (HyperFormula). Only the selected argument is evaluated in Excel.

=CHOOSE(index_num, value1, [value2], …)
index_numRequired. A number 1..254 selecting which value to return; can be a formula.
value1Required. The first candidate (literal, cell, range or expression).
value2…Optional. Up to 254 candidates total.
.bool-moat td.res-text{color:var(--cyan);font-weight:700;font-family:var(--mono)}
// 02 — Positional selection

What CHOOSE picks

CHOOSE(index_num,value1,value2,…) returns the value at position index_num — a 1-based pick from up to 254 arguments. The gallery is measured live. Note: the engine returns #NUM! for an out-of-range index where Excel returns #VALUE! (documented in the error library). Click any row.

Measured CHOOSE gallery

ExpressionResultWhy
=CHOOSE(2,"Apple","Banana","Cherry")Banana2nd literal
=CHOOSE(1,A2,A3,A4)Alice1st cell reference
=CHOOSE(2,10,20,30)202nd number
=CHOOSE(3,"Red","Green","Blue")Blue3rd literal
=CHOOSE(2,C2,C3,C4)2002nd cell value (C3)
=INDEX(A2:A8,CHOOSE(2,1,3,5))AliceCHOOSE picks position 3 for INDEX
=CHOOSE(MATCH("West",B2:B8,0),"first","second","third")secondMATCH computes the index
=CHOOSE(1,10,20,30)+CHOOSE(3,10,20,30)40Two picks summed (10+30)

The index is 1-based and can be computed (static)

ExpressionResultWhy
=CHOOSE(2,"Apple","Banana","Cherry")Banana2nd of three literals
=CHOOSE(1,A2,A3,A4)Alice1st of three cell references
=CHOOSE(3,100,200,300)3003rd numeric argument
=CHOOSE(MATCH("West",B2:B8,0),"first","second","third")secondIndex computed by MATCH — a lightweight switch
=INDEX(A2:A8,CHOOSE(2,1,3,5))AliceCHOOSE(2,1,3,5)=3 feeds INDEX a position
⚠ Out-of-range index: Excel returns #VALUE!; HyperFormula (this lab) returns #NUM!. Both mean the index is not 1..n. Wrap in IFERROR for a fallback. Keep index_num an integer — a fractional index is truncated.
When to use it: CHOOSE is ideal for a short fixed positional list (quarter names, scenario labels, tier multipliers). For value→result mapping or many branches, prefer SWITCH or a lookup table. Excel evaluates only the selected argument, so CHOOSE can gate expensive calculations.
// 03 — Try it live

Interactive CHOOSE playground

Edit the grid; reference-based picks update. Out-of-range index returns #NUM! in this engine (Excel returns #VALUE!).

A1Sample data — click any cell to edit, the formula re-evaluates live
Result
—
✓ readyHyperFormula 3.5
// 04 — Error library

The real-world error library

10 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.

// 05 — Cross-platform

Where CHOOSE works

CHOOSE is universal across Excel versions, Google Sheets and LibreOffice. The only cross-engine difference is the out-of-range error code (#VALUE! in Excel vs #NUM! in HyperFormula).

PlatformSupportNotesGotcha
✓ Supported full CHOOSE◐ Partial works with caveatsCompiled from public docs · verify against your build
// Go deeper

Master branching and selection

CHOOSE is one piece. The full course walks the toolkit end to end with live, measured examples.

  • CHOOSE — positional selection
  • Computed index with MATCH / MONTH
  • CHOOSE → INDEX composition
  • CHOOSE vs SWITCH vs a lookup table
Free while in beta
Browse the function library

No account needed. Every page has a live playground.

// 07 — FAQ

Frequently asked