< Go Back

Get column index in Excel Table

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.

 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar