Excel Study · Module 6: Lookups
Class 55CHOOSE
Intermediate1:49 videoFree
CHOOSE picks a value from a list by its position: =CHOOSE(B2,"Cash","Card","Bank") shows Card when B2 is 2, because 2 picks the second value. Fill it down and every payment code becomes a word; change a code and the word follows.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, E2 has a quarter number from 1 to 4. Using CHOOSE, write a formula for F2 that shows the quarter's months: Jan-Mar for 1, Apr-Jun for 2, Jul-Sep for 3 and Oct-Dec for 4. I will fill it down to F5.
The answer that works
✓ checked in Excel=CHOOSE(E2,"Jan-Mar","Apr-Jun","Jul-Sep","Oct-Dec")
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.