FUNCTION CATALOGUE / LOOKUP & REFERENCE
CHOOSECOLS Excel function
Returns selected columns from an array.
Correct sentence to use
Return columns [column numbers] from [array].
Modify this query in PlainFormula →Example formula
=CHOOSECOLS(A1:F20,1,3,6)
Returns specified columns.
Syntax
CHOOSECOLS(array, col_num1, [col_num2], …)
Argument signature: array, col_num1, [col_num2], …
Availability note
Available in supported Microsoft 365 / newer Excel versions; verify the exact release and platform.