All functions / Lookup
CHOOSE
Picks a value from a list by its position.
Syntax
=CHOOSE(index_num, value1, [value2], …)
Arguments
index_num: Which value to pick (1, 2, 3…).value: The options.
Example
=CHOOSE(2, "Bronze", "Silver", "Gold") → "Silver"