How to Use the CHOOSECOL Function in Google Sheets

Today, we will learn how to use the CHOOSECOL Function in Google Sheets, there are so many ways to filter data in a specific range, but fetching out columns can be very challenging; therefore, Google Sheets has provided a built-in function namely the CHOOSECOL function. With the help of this function, you can specify what columns to return in a specified range. In this guide, we will learn how to use the CHOOSECOL function in Google Sheets.

Advantages of CHOOSECOL Function in Google Sheets

It usually happens, sometimes we need the same data from one place to another, to test, calculate, monitor, etc. In such a situation, the CHOOSECOL function is much more beneficial so that you don’t need to retype the data again and again, you can get column data in return in jiffy by using the CHOOSECOL function. We will learn more about this function in the following guide on how to use the CHOOSECOL function in Google Sheets.

Syntax

=CHOOSECOLS(Array, col_num1, [col_num2])

CHOOSECOL: Function name.

Array: This is a range or array from which you want to get output.

Column number 1: Refers to the first column number of columns to return.

[Column number 2]: It is optional. Refers to the next column number of columns that you want to include in the results and so on.

Step-by-Step Procedure – How to Use CHOOSCOL Function in Google Sheets

Using the CHOOSECOL function in Google Sheets is just like child play, there is nothing hard to understand as there are only two arguments. In the following steps, we will see how to use the CHOOSECOL function in Google Sheets.

Step 1

In the following picture, we have a table containing obtained marks of different subjects regarding several students. Let’s suppose now you want to see the obtained marks of just one specific subject for all students, then how can we get it by using the CHOOSECOL function in Google Sheets?

Step 2

First, start the CHOOSECOL function in the cell by just writing the name of the function with an equal sign.

Step 3

According to the syntax of the CHOOSECOL function, we will provide an array of data ranges on which we need to target as I have given below.

Step 4

After providing the range, the second and last argument of the syntax is to provide the order number of the column from which you want to fetch the data as here we want to see the data of students and marks of Math subject that is on column 1 and 3 from the selected range so here, we have written 1 and 3 into the syntax.

Step 5

We are almost done now, as we press the Enter key, the specified column will automatically be returned to the selected cell as can be seen below.

In this way, we can get any column or number of columns data in return.

How to Use CHOOSCOL Function in Google Sheets – FAQs

Q: Can we get data in return to another sheet by using the CHOOSECOL function in Google Sheets?

A: Yes! Why not, you can’t only get data in return on the same sheet, but the CHOOSECOL function also works from one sheet to another sheet and you can easily get your data in return from one sheet to another sheet just you have to give the reference correctly. Let me show you practically in the following steps.

Step 1

Let’s suppose, here we have an empty table on a different sheet, now we want to same data from Sheet1 to the following sheet. Let’s see how we can get it by using the CHOOSECOL function.

Step 2

Simply, launch the CHOOSECOL function into the cell by just writing the function name with an equal sign.

Step 3

Now, here before giving the array or data range, you will have to provide the sheet reference like “Sheet1!” as written below or you can also move to the sheet and directly select the data range.

Step 4

Now, as per syntax, we will specify the order number of columns, here we want all columns in return so here we have mentioned all columns’ order numbers.

Step 5

Now, just press the Enter key, and your data will instantly be returned from one sheet to another sheet as resultant below.

Conclusion

This was all from my side regarding the CHOOSECOL function in Google Sheets, if there is any other query related to the above topic on how to use the CHOOSECOL function in Google Sheets, let us know in the comment section below. Keep learning and exploring with Office Demy.