CHOOSECOLS function - Zoho Sheet - Help Guide

CHOOSECOLS

Returns the specified columns from a given array.
 
Syntax
 
CHOOSECOLS(array; column; [column1];...)
array: The cell range containing the columns to return. E.g. A2:C9
column: The column(s) to return. E.g. 2
 
Examples
 
Formula
=CHOOSECOLS(A2:C9;1;3)
=CHOOSECOLS(A2:C9;2)

Get a hands-on experience of the function in the embedded range below. 



Possible Errors
 
Errors
Meaning
#NAME!
  • The function name is incorrect or invalid.
  • The given defined name (if any) is invalid.
  • There is a typo in the defined name used in the function.
  • Double quotes are missing for text values in the function.
  • Colon missing in a cell range reference.
#VALUE!
  • The given argument's data type is incorrect or invalid.
  • The given column value is 0, negative, or higher than the number of columns in the given array.
#REF!
  • The given cell reference is incorrect or invalid. This error may occur when a cell/range has been deleted, moved, or pasted over.
#NUM!
  • The given array is too large.
 
Similar Functions