# CHOOSECOLS

## Content

The function returns the specified columns from an array.

>type=note
> **Note**: CHOOSECOLS is a dynamic array formula, and you need to enable the dynamic array feature in the Workbook.

## Syntax

`CHOOSECOLS(array, col_num1, [col_num2], ...)`

## Arguments

The function provides the following arguments:

| Argument | Description |
| -------- | ----------- |
| *array* | [Required] Refers to the array containing the rows to be returned. |
| *col\_num1* | [Required] Refers to the first column to be returned. |
| *[col\_num2], ...* | [Optional] Refers to the additional columns to be returned. |

## Remarks

The function returns a #VALUE! error if the absolute value of any of the *col\_num* arguments is zero or exceeds the number of columns in the array.

## Examples

![choosecols-snapshot.png](https://cdn.mescius.io/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/choosecols-snapshot.41a3f5.png)