Excel allows us to find the column index in the Excel table with MATCH functions. This step-by-step tutorial will assist all levels of Excel users to learn how to get the column index in the Excel table. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Generic Formula
- Use the below-mentioned formula to get the column index in the Excel table.
=[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(name,Table[#Headers],0)
Syntax Explanations
- Parenthesis () – The main purpose of this symbol is to group the elements.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- MATCH ** – The **MATCH function helps to locate the position of a lookup value in a row, column, or table.
- *Table * – It contains list of values.
Practical Example
Let’s consider the below example. Here we are going to get the column index in the Excel table.
- For instance, you need to create a sample data in the Excel.
- Then, to get the index of a column in an Excel Table, you have to use the below given formula in the formula bar.
=[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(H4,Table1[#Headers],0)
- Now, you will get the result as shown below in the Excel.
- Finally, to get the index of a column in a table, you need to use the above given formulas for calculating each column.
A Short Summary
We hope that this short tutorial gives you guidelines on how to get the column index in the Excel table. ** ** Please leave a comment in case of any queries, and don’t forget to mention your valuable suggestions as well. Thank you so much for Visiting Our Site!! Continue learning on Geek Excel!! *Read more on Excel Formulas *!!
Read Ahead:
Top comments (0)