Returns specific columns of a range.


COLUMNS(range; columnIndex1; columnIndex2; …; columnIndexN)

  • range - the range from which the columns should be extracted - Value type: range

  • columnIndex1-N - the indicees of the columns which should be included in the return range - Value type: number


  • The order of the columns in the return range is the same as the order of the columnIndex parameters.

  • If a column does not exist in range, a column with empty cells is included in the range.

  • It is possible to use the same index multiple times, then the same column is included multiple times in the result range.


The left table is filled with the columns 1 and 3 of table1.

The left table is filled with several columns of table2 in a custom order. Including an empty column, by using 0 as index.