Excel CHOOSECOLS function

Function              CHOOSECOLS

Description        Excel CHOOSECOLS function returns the specified columns from an array. 

Syntax  CHOOSECOLS(array,col_num1,[col_num2],…)

array       The array containing the columns to be returned in the new array. Required.

col_num1       The first column to be returned. Required.

col_num2      Additional columns to be returned. Optional.

Example:

Note: – It will show a #VALUE! error if you put column number 0 or more than in the specified array.