CHOOSE Function Generator
CHOOSE returns a value from a list based on an index number. Great for mapping 1-N codes to labels without a lookup table.
Syntax
=CHOOSE(index_num, value1, [value2, ...])Try it — generate a CHOOSE formula
Examples
Day name from WEEKDAY
=CHOOSE(WEEKDAY(A2), "Sun","Mon","Tue","Wed","Thu","Fri","Sat")Index 1-7 → day names.
Quarter from month
=CHOOSE(CEILING(MONTH(A2)/3,1), "Q1","Q2","Q3","Q4")Month / 3 rounded up = 1..4 = quarters.
Priority labels
=CHOOSE(A2, "Low","Medium","High","Critical")Assumes A2 is 1-4.
Tips
- ✓index_num must be between 1 and the number of provided values.
- ✓Outside that range returns #VALUE!.
- ✓For lookup against any keys (not just 1-N), use VLOOKUP/XLOOKUP.
Related Formulas
WEEKDAY
WEEKDAY returns a number representing the day of the week for a given date. The ...
IFS
IFS evaluates conditions in order and returns the value for the first TRUE. Clea...
VLOOKUP
VLOOKUP searches for a value in the first column of a table and returns a value ...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free