Lookup & Reference Function - CHOOSECOLS

This amazing and new function from Office 365 enables you to return specific columns of data from an array!

The video shows the CHOOSECOLS function in use.

The written calculation is below:

=CHOOSECOLS(B3:D8,1,3)

​In this example, B3:D8 is the array or original data. The next arguments, 1 and 3, are the columns of data we want to return as a result of using the CHOOSECOLS function. You can include as many of these col_num arguments as you need.