CHOOSEROWS
Returns the specified rows from an array.
Lookup & ReferenceDynamic Arrays & LAMBDALookup & Matching EssentialsModern Excel Functions
What it does
Returns specific rows from an array or range, in the order specified.
Syntax
CHOOSEROWS(array, row_num1, [row_num2], ...)
Arguments
array(array) — The source array.row_num1(number) — Row number to return (can be negative to count from end).
Examples
Pick Row 2
Extract the second row.
FORMULA
=CHOOSEROWS(A1:C3, 2)
RESULT
[Bob, West, 700]
SAMPLE DATA
| A | B | C | |
|---|---|---|---|
| 1 | Name | Region | Sales |
| 2 | Alice | East | 500 |
| 3 | Bob | West | 700 |