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