CHOOSEROWS function - Zoho Sheet - Help Guide

CHOOSEROWS

Returns the specified rows from a given array.
 
Syntax
 
CHOOSEROWS(array; row; [row1];...)
array: The cell range containing the rows to return. E.g. A2:C9
row: The row(s) to return. E.g. 2
 
Examples
 
Formula
=CHOOSEROWS(A2:C9;2;4;6)
=CHOOSEROWS(A2:C9;5;7)

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 row value is 0, negative, or higher than the number of rows 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
  1. CHOOSECOLS