Intermediate
Lookup & Reference
CHOOSE
Returns a value from a list based on a position number you provide.
Compatibility: All Excel versions
Syntax
=CHOOSE(index_num, value1, [value2], ...)
Example
=CHOOSE(2,"Low","Medium","High")
When to Use It
Use CHOOSE to pick from a small, fixed set of options based on a number — e.g. converting a 1/2/3 priority code into a readable label.