Formulas > =CHOOSE()
How To Use CHOOSE() Function 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.
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
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