Lookup & Reference Excel 365 ◉ 17 views Dynamic Array

=CHOOSEROWS()

CHOOSEROWS function

Applies To: Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for Mac

=CHOOSEROWS(array,row_num1,[row_num2],…)

Hover argument names in the table for details.

Output typeArray

Popularity40 / 100

VolatileNo

Dynamic ArrayYes

Download sample .xlsx ▦ Try in Playground Dedicated file for this function — safe & lightweight · sample data + live formulas

⬇ Download Sample Workbook

A dedicated .xlsx for =CHOOSEROWS() with Persian sample data & live formulas — open in Excel and practice.

Download CHOOSEROWS.xlsx ~ 8–12 KB · No macros

%d questions — syntax, example & errors — test yourself!

Start quiz →

Argument	Type	Required	Description
`array`	Array	Required	The array containing the columns to be returned in the new array.
`row_num1`	Number	Required	The first row number to be returned.
`row_num2`	Number	Optional	Additional row numbers to be returned.

▦ Data

Example 1 =CHOOSEROWS(A2:B7,1,3,5,1)

Example 2 =CHOOSEROWS(A2:B7,{1,3},5,1)

Example 3 =CHOOSEROWS(A2:B7,-1,-2)

#VALUE! Excel returns a #VALUE error if the absolute value of any of the row_num arguments is zero or exceeds the number of rows in the array.