What CHOOSE does
CHOOSE returns one item from a list based on a numeric position. It is useful when you need a compact mapping formula or when you want to rearrange inputs before passing them into another function.
Practical examples
Return a label from a short list
=CHOOSE(A2,"Low","Medium","High")
If A2 contains 2, Excel returns Medium.
Reorder arrays for a lookup pattern
=MATCH("Red",CHOOSE({1,2},B2:B10,A2:A10),0)
CHOOSE can help build temporary array structures when you need a more flexible lookup setup.
Common mistakes and notes
index_num must point to a real position
If the index points past the values you supplied, Excel returns an error instead of a fallback result.
CHOOSE is best for short lists
When the mapping grows large, a lookup table with XLOOKUP or INDEX plus MATCH is usually easier to maintain.
Position numbers start at 1
The first supplied value is position 1. There is no zero position.