Excel Formulas to Get column index in Excel Table ~ Quickly!!
Tags: excelformula, excelformulas
Published: 2021-10-28 09:25:56

---
title: Excel Formulas to Get column index in Excel Table ~ Quickly!!
published: true
date: 2021-10-27 09:39:11 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-get-column-index-in-excel-table-quickly/
---

Excel allows us to find the column index in the Excel table with **[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)**[ ](https://geekexcel.com/formulas-to-count-with-countif-function-in-excel-office-365/)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](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](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)** 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.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Sample-data-58-1024x457.png)<figcaption>Sample data</figcaption>

- Then, to get the index of a column in an Excel Table, you have to use the below given formula in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(H4,Table1[#Headers],0)

```

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Use-Formula-2-1024x499.png)<figcaption>Use the Formula</figcaption>

- Now, you will get the **result** as shown below in the Excel.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Result-for-ID-value-1024x446.png)<figcaption>Result for ID</figcaption>

- Finally, to get the **index of a column** in a table, you need to use the above given **formulas** for calculating each column.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/10/Final-output-2-1024x445.png)<figcaption>Final Output</figcaption>

## 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](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Ahead:**

- **[Excel Formulas to Count table columns in Excel 365!!](https://geekexcel.com/excel-formulas-to-count-table-columns-in-excel-365/)**
- **[Convert a Table to the Data Range in Excel Office 365!!](https://geekexcel.com/convert-table-to-data-range/)**
- **[Excel Formulas to Sum the Range with INDEX Function!!](https://geekexcel.com/excel-formulas-to-sum-the-range-with-index/)**
- **[Excel Shortcut: INSERT TABLE in the Worksheet in Excel 365!!](https://geekexcel.com/ms-excel-shortcut-to-insert-table-in-the-worksheet/)**