A measured CHOOSE gallery: positional picks, computed indices and CHOOSE→INDEX, every value engine-verified. Live, editable, free.
1-based selection. Out-of-range index → #VALUE! (Excel) / #NUM! (HyperFormula). Only the selected argument is evaluated in Excel.
CHOOSE(index_num,value1,value2,…) returns the value at position index_num — a 1-based pick from up to 254 arguments. The gallery is measured live. Note: the engine returns #NUM! for an out-of-range index where Excel returns #VALUE! (documented in the error library). Click any row.
| Expression | Result | Why |
|---|---|---|
| =CHOOSE(2,"Apple","Banana","Cherry") | Banana | 2nd literal |
| =CHOOSE(1,A2,A3,A4) | Alice | 1st cell reference |
| =CHOOSE(2,10,20,30) | 20 | 2nd number |
| =CHOOSE(3,"Red","Green","Blue") | Blue | 3rd literal |
| =CHOOSE(2,C2,C3,C4) | 200 | 2nd cell value (C3) |
| =INDEX(A2:A8,CHOOSE(2,1,3,5)) | Alice | CHOOSE picks position 3 for INDEX |
| =CHOOSE(MATCH("West",B2:B8,0),"first","second","third") | second | MATCH computes the index |
| =CHOOSE(1,10,20,30)+CHOOSE(3,10,20,30) | 40 | Two picks summed (10+30) |
| Expression | Result | Why |
|---|---|---|
| =CHOOSE(2,"Apple","Banana","Cherry") | Banana | 2nd of three literals |
| =CHOOSE(1,A2,A3,A4) | Alice | 1st of three cell references |
| =CHOOSE(3,100,200,300) | 300 | 3rd numeric argument |
| =CHOOSE(MATCH("West",B2:B8,0),"first","second","third") | second | Index computed by MATCH — a lightweight switch |
| =INDEX(A2:A8,CHOOSE(2,1,3,5)) | Alice | CHOOSE(2,1,3,5)=3 feeds INDEX a position |
Edit the grid; reference-based picks update. Out-of-range index returns #NUM! in this engine (Excel returns #VALUE!).
10 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.
CHOOSE is universal across Excel versions, Google Sheets and LibreOffice. The only cross-engine difference is the out-of-range error code (#VALUE! in Excel vs #NUM! in HyperFormula).
| Platform | Support | Notes | Gotcha |
|---|
CHOOSE is one piece. The full course walks the toolkit end to end with live, measured examples.