CHOOSE

CHOOSE function in Google Sheets: Picks a value from a list by position.

November 5, 2026

Lookup & Reference function · Google Sheets

CHOOSE function

Picks a value from a list by position.

Platform	Status
Excel	Listed
Google Sheets	Listed

Reference entry. Syntax, tested examples and a practice file arrive with the full guide. Open the official function list.