CHOOSE

Try it

When to use it

When should I use CHOOSE instead of LOOKUP?

Use CHOOSE to pick one value from a fixed list by its position number; use LOOKUP to search a sorted vector for a matching value.

Can CHOOSE return text or only numbers?

CHOOSE can return any value type, including text, numbers, or the result of another formula, based on the index you pass.

Use cases

Convert a month number to a quarter label

=CHOOSE(7, "Q1", "Q1", "Q1", "Q2", "Q2", "Q2", "Q3", "Q3", "Q3", "Q4", "Q4", "Q4")

Select a commission rate by tier number

Used in

operations · sales

Syntax

CHOOSE(index, value1, value2, ...)

Examples

=CHOOSE(2,10,20,30) // => 20
=CHOOSE(3,100,200,300) // => 300
=CHOOSE(1,10,20,30) // => 10