Excel Formulas to get Dynamic reference Table name!!
Tags: excelformula, excelformulas
Published: 2021-10-28 04:18:22

---
title: Excel Formulas to get Dynamic reference Table name!!
published: true
date: 2021-10-27 07:14:46 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-get-dynamic-reference-table-name/
---

With the **INDIRECT function** in combination with functions like **SUM** , we can do the dynamic reference of the table names to perform different calculations. This tutorial will walk through the steps to dynamically reference a set of data in other functions. Let’s see the simple formula used for  **dynamic reference table names** in Excel. 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

- You need to use the below-given formula to get dynamic reference table names.

```
=[SUM](https://geekexcel.com/sum-function/)([INDIRECT](https://geekexcel.com/use-indirect-function-in-microsoft-excel-365-in-easy-ways/)(table&"[column]"))

```

## Syntax Explanation

- **COLUMN** – This function is used to return column numbers for reference. Read more on the **[COLUMN Function](https://geekexcel.com/use-column-function-in-microsoft-excel-365-simple-methods/)**.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **SUM** – The [**SUM function**](https://geekexcel.com/sum-function/) adds values to the cells.
- **INDIRECT** – The **[INDIRECT Function](https://geekexcel.com/use-indirect-function-in-microsoft-excel-365-in-easy-ways/)** in Excel returns a valid reference from a given text string.

## Practical Example

- Firstly, you need to **create a sample data** in Microsoft Excel.

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

- Then, to calculate the total value for the region west, 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/)**.

```
=SUM(INDIRECT(K5&"[Amount]"))

```

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

- Now, you will get the **result for the region west** as given below in the **cell L5**.

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

- After that, to calculate the total value for the region central, 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/)**.

```
=SUM(INDIRECT(K6&"[Amount]"))

```

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

- You will get the **result for the region central** as given below in the **cell L6**.

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

- Now, to calculate the total value for the region east, 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/)**.

```
=SUM(INDIRECT(K7&"[Amount]"))

```

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

- Finally, you will get the **result for the region east** as given below in the **cell L7**.

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

## Closing Words

Here, we have described the simple **formulas for**  **dynamic reference table names in Excel**. I hope this article helps you. Feel free to ask back any **questions** and let us know how it goes. I will keep working with you until it’s resolved.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Related Articles:**

- **[Excel Formulas to Generate Series of Date by Day ~ Easy Tricks!!](https://geekexcel.com/excel-formulas-to-generate-series-of-date-by-day/)**
- **[Excel Formulas to Create the Series of Dates by Month ~ Simple Guide!!](https://geekexcel.com/excel-formulas-to-create-the-series-of-dates-by-month-simple-guide/)**
- **[How to Change Chart Data as Per Selected Cell in Excel VBA?](https://geekexcel.com/how-to-change-chart-data-as-per-selected-cell-in-excel-vba/)**
- **[Excel Formulas to Create a Series of Dates by Year ~ Complete Guide!!](https://geekexcel.com/excel-formulas-to-create-a-series-of-dates-by-year/)**
- **[Use Excel COLUMN Function in Office 365 – Simple methods!!](https://geekexcel.com/use-column-function-in-microsoft-excel-365-simple-methods/)**