Return the n-th item from a set of values based on an index number.
Copy this formula
=CHOOSE(A2, "Low", "Medium", "High")CHOOSE(index, value1, value2, …) returns the value at the given position. It's perfect for mapping 1/2/3 to labels, or picking which column or formula to use based on a selector.
=CHOOSE(WEEKDAY(A2), "Sun","Mon","Tue","Wed","Thu","Fri","Sat")→TueTurns a weekday number into a label.
CHOOSE picks by a 1-based number; SWITCH matches a value; IFS evaluates conditions. Use CHOOSE when you have a position index.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.