Returns a value from a list, given an index number.
Syntax
value: The values from which one is to be returned. Can be a value, cell reference, or formula. E.g. "Sunday","2/2/19"
Remarks
CHOOSE is flexible and can be combined with other functions. For example, it can be used along with RANDBETWEEN to create a random dataset (=RANDBETWEEN(1,5);"Value1";"Value2";"Value3";"Value4";"Value5").
Examples
Formula | Result |
=CHOOSE(1;2.3;3.6;6.8) | 2.3 |
=CHOOSE(A2;"Sunday";"Monday";"Tuesday";"Wednesday";"Thursday";"Friday";"Saturday") | Sunday |
=CHOOSE(2;"1/2/19";"2/2/19";"2/3/19") | 2/2/19 |
Possible Errors
Errors | Meaning |
#N/A! |
|
#NAME! |
|
#VALUE! |
|
#REF! |
|
Similar Functions
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
Write to us: support@zohoforms.com