Home › Functions › Lookup & Reference › =CHOOSE()
Lookup & Reference All versions ◉ 17 views

=CHOOSE()

Uses index_num to return a value from the list of value arguments. Use CHOOSE to select one of up to 254 values based on the index number. For example, if value1 through value7 are the days of the week, CHOOSE returns one of the days when a number between 1 and 7 is used as index_num.

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=CHOOSE(index_num, value1, [value2], ...)
Hover argument names in the table for details.
Output typeMixed
Popularity60 / 100
VolatileNo
Dynamic ArrayNo
📥 Download sample .xlsx — Coming soon ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas
Share:

⬇ Download Sample Workbook

A dedicated .xlsx for =CHOOSE() with Persian sample data & live formulas — open in Excel and practice.

  • Sheet “Sample” — data table + formula in place
  • Sheet “Guide” — syntax, arguments & tips from this page
  • Instant & secure (token + rate limit)
📥 Download CHOOSE.xlsx — Coming soon ~ 8–12 KB · No macros

⇪ Share

Send this function to friends

🧠 🧠 Quiz this function

%d questions — syntax, example & errors — test yourself!

◧ Arguments

ArgumentTypeRequiredDescription
index_num Number Required Specifies which value argument is selected. Index_num must be a number between 1 and 254, or a formula or reference to a cell containing a number between 1 and 254. If index_num is 1, CHOOSE returns value1; if it is 2, CHOOSE returns value2; and so on. If index_num is less than 1 or greater than the number of the last value in the list, CHOOSE returns the #VALUE! error value. If index_num is a fraction, it is truncated to the lowest integer before being used.
value1 Any type Required , value2, ... Value 1 is required, subsequent values are optional. 1 to 254 value arguments from which CHOOSE selects a value or an action to perform based on index_num. The arguments can be numbers, cell references, defined names, formulas, functions, or text.

▣ Examples

مقدار آرگومان دوم فهرست (مقدار سلول A3) =CHOOSE(2,A2,A3,A4,A5)
مقدار آرگومان چهارم فهرست (مقدار سلول B5) =CHOOSE(4,B2,B3,B4,B5)
مقدار آرگومان سوم فهرست =CHOOSE(3,"Wide",115,"world",8)
جمع محدودهٔ ‎A2:A4‎؛ تابع CHOOSE سلول A4 را به‌عنوان انتهای محدوده برای SUM برمی‌گرداند =SUM(A2:CHOOSE(2,A3,A4,A5))

✦ Tips

  • If index_num is an array, every value is evaluated when CHOOSE is evaluated.
  • The value arguments to CHOOSE can be range references as well as single values. For example, the formula:
  • =SUM(CHOOSE(2,A1:A10,B1:B10,C1:C10))
  • evaluates to:

⚠ Common Errors

#VALUE! If index_num is less than 1 or greater than the number of the last value in the list, CHOOSE returns the #VALUE! error value.
Fix: Check the first argument

⇄ Related Functions

=IF() How to use the IF function in Excel to make logical comparisons between data values. =INDEX() Returns the value of an element in a table or an array, selected by the row and column number indexes. Use the array form if the first argument to INDEX is an array constant. Returns the reference of the cell at the intersection of a particular row and column. If the reference is made up of non-adjacent selections, you can pick the selection to look in. =SWITCH() The SWITCH function evaluates one value (called the expression) against a list of values, and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned. If there are no matching values, and no default argument is supplied, the SWITCH function returns the #N/A! error.

💬 Comments & Q&A 0 approved

🔒 Your comment will be published after review.

Share your thoughts — visible after admin approval

No comments yet — be the first!

✍️ Add comment / question

captcha
🔒 Your comment will be published after review.