Excel like a finance pro.

The functions, VBA, and shortcuts a finance operator actually uses — curated, with CFO examples. Prefer them pre-built? Grab a ready-made model.

← All functions

CHOOSE

Lookups & references

The scenario switch. One cell flips a model between base, upside and downside.

Difficulty

Amateur

Excel file

1What is it?

CHOOSE takes an index and returns the nth thing you listed. That sounds trivial until you use it as a scenario switch: one cell holding 1, 2 or 3, and every assumption in the model reading `=CHOOSE($B$1, base, upside, downside)`. Changing that one cell moves the whole model. It's simpler and far less fragile than the nested IFs people reach for instead, and unlike a lookup table it needs no range to maintain. Its real limit is that it evaluates every argument, so a slow or error-producing option costs you even when it isn't selected.

2What it looks like

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

index_num: Which one to return, counting from 1. A decimal is truncated, not rounded — 2.9 returns the second.
value1, …: Up to 254 values, references or even ranges. They can be different types.

3When you use it

Drive base / upside / downside from a single scenario cell.
Turn a numeric code into a label without a lookup table.
Pick which quarter's range to sum, by passing ranges as the options.

4See it in action

Change the inputs — the formula and result update live. Prefer the real thing? Download the Excel file and open it in Excel.

Flip the scenario and watch every assumption change together.

=CHOOSE($B$1, 486000, 552000, 430000)Revenue: $486,000

	A	B	C
1	Field	Value	Result
2	Scenario (1/2/3)		Revenue: $486,000
3	Revenue	—	Gross margin: 38%
4	Gross margin	—	Net income: $20,680
5			Every assumption reads the same cell, so one change moves all of them.

The lime cell holds the formula — click it (or any cell) to see its contents in the bar above, just like Excel. Edit the blue cells to watch it recompute.

Operating expenses

5Common errors

#VALUE!index_num is below 1 or above the number of options.

Fix: Guard it: CHOOSE(MEDIAN(1, B1, 3), …) clamps the index into range.

Always returns the first optionThe index cell is text rather than a number — common when it comes from a dropdown.

Fix: Use VALUE() on it, or set the Data Validation list to numbers and show labels elsewhere.

Slow, or an error you can't seeCHOOSE evaluates EVERY argument, not just the chosen one.

Fix: Keep the options cheap. If one option errors, the whole formula can error even when it isn't selected.

Breaks when a scenario is insertedThe options are positional.

Fix: For more than a handful, a lookup table with named scenarios is easier to maintain.

6Better functions & alternatives

SWITCH — Better when you're matching a VALUE rather than a position — a status code to a label.
INDEX — Reads from a range of options you can see and edit, rather than options buried in the formula.
Scenario Manager — The no-formula version: named sets of inputs you switch between. See the tip.

Want CHOOSE already wired into a model? Wauvel's free tools download as branded, formula-driven Excel.

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.