What is the column number of a match in Google Sheets?

By /

The column number of a match in Google Sheets refers to the numerical position of a column within a spreadsheet. It starts at 1 for the first column and increases by 1 for each subsequent column. This number can be used to locate and reference specific columns within a sheet, making it easier to organize and analyze data.

You can use the following methods to return the column number of a match in Google Sheets:

Method 1: Return Column Number of Match within Table

=MATCH(G2, C1:E1, 0)

This particular formula will look up the value in cell G2 in the range C1:E1 and then return the column number that matches the value in cell G2.

Method 2: Return Column Number of Match within Entire Spreadsheet

=MATCH(G2, $1:$1, 0)

This particular formula will look up the value in cell G2 in the entire first row of the spreadsheet and then return the column number that matches the value in cell G2.

The following examples show how to use each method in practice with the following dataset in Google Sheets:

Note: The value of 0 in the last argument of the MATCH function tells Google Sheets to look for an exact match.

Example 1: Return Column Number of Match within Table

We can type the following formula into cell H2 to find the column number in the range C1:E1 that matches the value in cell G2:

=MATCH(G2, C1:E1, 0)

The following screenshot shows how to use this formula in practice:

Google Sheets return column number of match

The formula returns a value of 3 since the name “Assists” is located in column 3 of the range that we specified.

Example 2: Return Column Number of Match within Entire Spreadsheet

=MATCH(G2, $1:$1, 0)

The following screenshot shows how to use this formula in practice:

The formula returns a value of 5 since the name “Assists” is located in column 5 of the entire spreadsheet.

Note that the range $1:$1 in the formula indicates that we should look for the value “Assists” in row 1 of the entire spreadsheet.

Note: You can find the complete documentation for the MATCH function in Google Sheets .

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

x

Related terms:

  1. # Check if One Column Value Exists in Another Column in Google Sheets
  2. How to use Google Sheets: INDEX MATCH with Multiple Criteria
  3. How can I use INDEX MATCH in Google Sheets to retrieve multiple results?
  4. How can I find a partial match in two columns using Google Sheets?
  5. Count Specific Characters in Google Sheets How to count specific characters in google sheets?
  6. Google Sheets: Stack Multiple Columns into One Column
  7. How to Use Column Names in Google Sheets Query
  8. How to Multiply Column by a Constant in Google Sheets
  9. How to Multiply Column by a Percentage in Google Sheets?
  10. How can I remove duplicate rows in Google Sheets based on one column?