CHOOSECOLS
Returns the specified columns from an array
Syntax
CHOOSECOLS(array, col_num1, [col_num2], ...)
Parameters
- array: Required. The array containing the columns to be returned
- col_num1: Required. The first column to be returned
- col_num2: Optional. Additional columns to be returned
Example
=CHOOSECOLS(A1:D5, 1, 3)