CHOOSEROWS Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

CHOOSEROWS is an Excel Lookup & Reference function. Returns specific rows from an array by their position.

CHOOSEROWS syntax

=CHOOSEROWS(array, row_num1, ...)

CHOOSEROWS is used to pull matching data from one part of a workbook into another.

Open the live Excel-style spreadsheet and try CHOOSEROWS yourself. No Excel install or sign-up needed to start.

What does the CHOOSEROWS function do in Excel?

Returns specific rows from an array by their position.

What is the syntax of CHOOSEROWS in Excel?

The syntax is =CHOOSEROWS(array, row_num1, ...). array: The range or array to evaluate; row_num1: The row position to return.

Where can I practice CHOOSEROWS online for free?

Open the free live spreadsheet on Cellgrids and try CHOOSEROWS yourself. No Excel install is needed and you can start without signing up.