**Get column index in Excel Table**

To find column index in an excel table, one can use MATCH function.

## Formula

` =MATCH(name,Table[#Headers],0)`

## Explanation

*Figure 1. Example of how to get column index in*

**In case, knowing the only address, how do you find column and row index?**

Knowing the address of a cell makes it easy to find a column index or a row index. If the address of the cell is NK60, the line number is 60; and you can get the column index using the formula = column (NK60).

**In case, knowing only row address or column address, how do you find column and row index?**

Sometimes you might know the value in a particular column or row and you want to identify its row or column number. You can get them using the MATCH function. Suppose you have a table, as shown in the screenshot below.

*Figure 2. ** How to get column index in*

Suppose you want to know the row index of “ink” and you already know that it is in column A, you can use this formula in

`= MATCH ("ink", A:A,0)`

a blank cell to get its row index. After entering the formula, press Enter and the row index of the cell containing the Ink will be displayed.

Suppose you want to know the column index of “ink” and you already know that it is on line 4, you can use this formula

`=MATCH("ink",4:4,0) `

in a blank cell to get its column index . After entering the formula, press Enter and the column index of the cell containing the Ink will be displayed.

## Leave a Comment