Return a value from a list based on a position number.
Syntax
CHOOSE(index_num, value1, [value2], …)Arguments
index_numrequired
Which item to return (1-based).
value1…required
The list of values to choose from.
CHOOSE picks the Nth item from a list of values or references. It's useful for turning a number (1, 2, 3) into a label, scenario, or column reference without a lookup table.
=CHOOSE(2, "Low", "Medium", "High")→MediumReturns the 2nd item.
=CHOOSE(WEEKDAY(A2), "Sun","Mon","Tue","Wed","Thu","Fri","Sat")→WedMaps a weekday number to a name.
Provide an index
A number from 1 to N selects the item.
List the options
Add values or references in order.
CHOOSE selects purely by a 1-based position number; IFS/SWITCH branch on conditions or matched values.