FormulaCraft

CHOOSECOLS

CHOOSECOLS extracts one or more columns from an array using column index numbers relative to the array. You can reorder columns, repeat them, or exclude unwanted ones without rearranging the source data. It is an Excel 365 dynamic array function that spills automatically.

Excel
=CHOOSECOLS(A1:D3,1,3)
Google Sheets
=CHOOSECOLS(A1:D3,1,3)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1A1:D3 is the source array from which columns will be selected.
  2. 21 selects the first column of the array (column A in this case).
  3. 33 selects the third column; both columns are returned side by side in a spilled result.

Need a version for your data?

Try: “Extract only the Name and City columns from a four-column table”

Related

VLOOKUPXLOOKUPINDEX / MATCH

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: