Manuals/calci/CHOOSE

CHOOSE(indexnum, val1, val2, .....)

where,

• $indexnum$ the relative position of value to be selected
• $val1,val2,...$ are value arguments or cell references to the values

CHOOSE() selects a value from list of arguments with respect to the specified index position.

Description

CHOOSE(indexnum, val1, val2, .....)

e.g. CHOOSE(2,10,20,30) displays 20 as a result.

• CHOOSE() selects the value from the list of values depending on the specified $indexnum$. e.g. If $indexnum$ is 2, Calci displays $val2$.
• If $indexnum$ is not an integer, Calci displays #NULL error message.
• If $indexnum$ <1 or $indexnum$ > number of values in the list, Calci displays #N/A error message.
• Arguments $val1,val2,...$ can be numbers, text, cell references, formulas, functions etc.

Examples

Red	23
Blue	12
Yellow	3
Green	-1
Orange	4

=CHOOSE(5,A1,A2,A3,A4,A5) : Finds the value with index number '5' in the cell range A1 to A5. 
Displays Orange.
=CHOOSE(2,A1,A2,A3,A4,A5) : Finds the value with index number '2' in the cell range A1 to A5. 
Displays Blue.
=CHOOSE(4,B1,B2,B3,B4,B5) : Finds the value with index number '4' in the cell range B1 to B5. 
Displays -1.
=CHOOSE(10,B1,B2,B3,B4) : Specified index number '10' is greater than the cell range, hence 
Calci displays #N/A error message.

Related Videos

CHOOSE

See Also

• MATCH
• LOOKUP
• VLOOKUP
• HLOOKUP

References

• String
• Find String