CHOOSEROWS

CHOOSEROWS extracts one or more rows from an array by specifying their row index numbers. You can repeat rows, reorder them, or select a non-contiguous subset. It is a modern Excel 365 function that spills results and is useful for reordering datasets or pulling specific records without helper columns.

Excel

=CHOOSEROWS(A1:C4,2,4)

Google Sheets

=CHOOSEROWS(A1:C4,2,4)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

How it works

1A1:C4 is the source array from which rows will be selected.
22 selects the second row of the array (row index is relative to the array, not the sheet).
34 selects the fourth row; both rows are returned stacked vertically in a spilled result.

Need a version for your data?

Try: “Pull only the 2nd and 4th rows out of my data table”

VLOOKUP XLOOKUP INDEX / MATCH

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026

CHOOSEROWS

Try it with your data

How it works

Related