Formulas > =CHOOSE()
How to Use CHOOSE() in Google Sheets
Description
How To Actually Use CHOOSE() in Sheets
CHOOSE(index, choice1, [choice2, ...])
Try CHOOSE yourself
In cells A1:A5, list five fruits. In cell B1, use the CHOOSE formula to select the third fruit from the list in A1:A5.
Hints (3)
-
Remember that CHOOSE uses an index to select from the list.
-
The index starts at 1, not 0.
-
Make sure to reference the correct cells in your formula.
Sheet art with CHOOSE
CHOOSE maps a number to dice faces, zodiac signs, scene stages, and other pick-one visuals in a single cell.
Sheet art examples with CHOOSE()
8 copy-paste formulas from the Playground use CHOOSE(). Click a card to copy the full formula into Google Sheets. Showing a curated set from 153 matching examples.
=CHOOSE(A1,"⚀","⚁","⚂","⚃","⚄","⚅")
⚂
=CHOOSE(LOOKUP(MONTH(A1)*100+DAY(A1),{101,120,219,321,420,521,621,723,823,923,1023,1122,1222},{1,2,3,4,5,6,7,8,9,10,11,12,1}),"♑","♒","♓","♈","♉","♊","♋","♌","♍","♎","♏","♐")
♋
=CHOOSE(A1,"📕","📖","📗","✅")
📖
=CHOOSE(A1,"🧱","😶","😐","✍️","🚀")
✍️
=CHOOSE(RANDBETWEEN(1,6),"⚀","⚁","⚂","⚃","⚄","⚅")
⚂
=CHOOSE(A1,"😍 Ecstatic","😊 Happy","😐 Neutral","😟 Grumpy","😴 Resting")
😊 Happy
=CHOOSE(A1,"🥉","🥈","🥇","🏆")
🥇
=CHOOSE(RANDBETWEEN(1,12),"♑","♒","♓","♈","♉","♊","♋","♌","♍","♎","♏","♐")
♋
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
More related tutorials
Transcript-matched member videos for CHOOSE(). Click through to watch.
Learn Google Sheet Formulas The Hard Way
Calculate ROAS in Google Sheets
Write Apps Script to Create a New Google Sheets Formula
Learn more about the CHOOSE() formula:
Generate a CHOOSE() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses CHOOSE(). 2 free AI generations, no signup. Members get unlimited use.
Generate a CHOOSE() formula