Return a value by its position number with CHOOSE
=CHOOSE(B2,"Very poor","Poor","Neutral","Good","Excellent")Excel · result on the sample sheet: 6 rows (C2:C7)
Describe what you need and get a working CHOOSE formula for Excel and Google Sheets, tested on real data before you copy it. CHOOSE returns the item at a given position from a list you type into the formula: 1 returns the first item, 2 the second, and so on.
Each formula below was calculated on its own sample sheet. Open one to see the sheet, why it works, and to try it yourself.
=CHOOSE(B2,"Very poor","Poor","Neutral","Good","Excellent")Excel · result on the sample sheet: 6 rows (C2:C7)
=TEXT(DATE(2026,A2,1),"mmmm")Excel · result on the sample sheet: 5 rows (B2:B6)
=INDEX($F$2:$F$8,WEEKDAY(A2,2))Excel · result on the sample sheet: 6 rows (B2:B7)
=SUM(CHOOSE(G1,B2:B7,C2:C7,D2:D7))Excel · result on the sample sheet: $289,250
=A2&IF(AND(MOD(A2,100)>=11,MOD(A2,100)<=13),"th",CHOOSE(MIN(MOD(A2,10)+1,5),"th","st","nd","rd","th"))Excel · result on the sample sheet: 11 rows (B2:B12)
You describe the task in plain English, and it writes the formula, using CHOOSE where that's the right tool, for your table or a sample one. The formula is run in our engine in Excel and Google Sheets mode before you see it, so you get its result, not just a guess.
CHOOSE returns the item at a given position from a list you type into the formula: 1 returns the first item, 2 the second, and so on.
Yes. Each example below opens a page where you try the formula in a live grid and it's checked as you go, and the CHOOSE function page has a practice exercise.