CHOOSE
Chooses a value from a list of values.
Lookup & ReferenceLookup & Matching Essentials
What it does
Returns a value from a list based on an index number.
Syntax
CHOOSE(index_num, value1, [value2], ...)
Arguments
index_num(number) — 1-based position of the value to return.
Examples
Pick a plan name
Return the plan name based on an index.
FORMULA
=CHOOSE(A2,"Basic","Pro","Enterprise")
RESULT
Pro
SAMPLE DATA
| A | |
|---|---|
| 1 | Index |
| 2 | 2 |
| 3 | 1 |
| 4 | 3 |