Return a value from a list based on a position number.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
CHOOSE(index_num, value1, [value2], …)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")Result: Medium
Returns the 2nd item.
=CHOOSE(WEEKDAY(A2), "Sun","Mon","Tue","Wed","Thu","Fri","Sat")Result: Wed
Maps a weekday number to a name.
CHOOSE selects purely by a 1-based position number; IFS/SWITCH branch on conditions or matched values.