fx =CHOOSE(A1,"Jan","Feb","Mar","Apr")ABCOrder #1042$1,250ApprovedOrder #1043$450ReviewOrder #1044$3,200Approved
🔀 Logic

CHOOSE Formula for Logic

Return value based on index number. Copy-paste ready for Excel, Google Sheets, and Airtable.

=CHOOSE(A1,"Jan","Feb","Mar","Apr")
When you need this: When a form returns month as a number (1–12) in A1 and you need to convert it to month name ("January" to "December").

How it works

  1. 1CHOOSE takes an index number (A1, must be 1–254) and returns the value at that position.
  2. 21 returns "Jan", 2 returns "Feb", 3 returns "Mar", etc.
  3. 3Useful for mapping codes to labels.

Variations

CHOOSE for quarter labels
=CHOOSE(CEILING(MONTH(A1)/3,1),"Q1","Q2","Q3","Q4")
CHOOSE with error handling
=IFERROR(CHOOSE(A1,"Jan","Feb","Mar"),"Invalid")

Related Formulas

IF — Return different values based on a conditionLogicIFS — Check multiple conditions (cleaner than nested IF)LogicIFERROR — Show a custom value instead of an errorLogicAND / OR — Check if multiple conditions are trueLogic

Need a formula that's not here?

Generate custom formula →