# COLUMN

#### Syntax <a href="#syntax.9" id="syntax.9"></a>

**COLUMN**(*range*; *columnIndex*)

* *range* - a range of values - ***Value type**: range*
* *columnIndex* - the index of the column to return - ***Value type**: number (optional, default value: 1)*

#### Remarks <a href="#remarks.6" id="remarks.6"></a>

* If *columnIndex* is greater than the number of columns in *range* or smaller than 1, an empty column with the same amount of rows as *range* is returned.
* *columnIndex* can contain the text “last”. In this case, the last column of *range* is returned.
* The function COLUMN can be used to ensure that a parameter or operand is always handled as a column during an operation.

#### Example

The left widget is filled with the second column of table2, by calling the COLUMN function with 2 as second parameter.

<figure><img src="https://3148043601-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FL43fiRbeRtPnTjMpbGNO%2Fuploads%2Fgit-blob-5540371d9f74c619b24c80b8c7c37c4f523ee965%2Fgrafik%20(329).png?alt=media" alt=""><figcaption></figcaption></figure>