Skip to content
Excel

CHOOSE function in Excel

Chooses a value from a list of values

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

CHOOSE syntax and parameters

Three arguments, two required.

  • index_numnumberRequired
  • value1anyRequired
  • value2anyRepeating

CHOOSE examples

Formulas you'll actually reuse.

  1. A weekday label from a date, no lookup table needed:

    =CHOOSE(WEEKDAY(A2, 2), "Mon", "Tue", "Wed", "Thu", "Fri", "Sat", "Sun")

    Result"Thu"

  2. Total whichever scenario column a 1/2/3 selector cell points at:

    =SUM(CHOOSE(B2, D2:D13, E2:E13, F2:F13))

    Result148200

CHOOSE in Google Sheets

Same name — your formula ports as-is.

Try CHOOSE in the playground

Edit the example — nothing to install.

Preloaded with the CHOOSE formula from Example 1 — change anything and watch it respond.

Loading the editor…

CHOOSE errors

What they mean — and the fixes.

  • #VALUE!

    The index is outside 1…N — it must point at one of the listed values (fractions are truncated, so 0.9 counts as 0).

Related functions

More ways Excel gets this done.