CHOOSECOLS Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

CHOOSECOLS is an Excel Lookup & Reference function. Returns specific columns from an array by their position.

CHOOSECOLS syntax

=CHOOSECOLS(array, col_num1, ...)

CHOOSECOLS is used to pull matching data from one part of a workbook into another.

Open the live Excel-style spreadsheet and try CHOOSECOLS yourself. No Excel install or sign-up needed to start.

What does the CHOOSECOLS function do in Excel?

Returns specific columns from an array by their position.

What is the syntax of CHOOSECOLS in Excel?

The syntax is =CHOOSECOLS(array, col_num1, ...). array: The range or array to evaluate; col_num1: The column position to return.

Where can I practice CHOOSECOLS online for free?

Open the free live spreadsheet on Cellgrids and try CHOOSECOLS yourself. No Excel install is needed and you can start without signing up.