Excel Formulas: Dynamic Lookup with INDIRECT Function!!
Tags: excelformula, excelformulas
Published: 2020-12-19 11:15:46

---
title: Excel Formulas: Dynamic Lookup with INDIRECT Function!!
published: true
date: 2020-12-19 10:02:43 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-dynamic-lookup-with-indirect/
---

If you have multiple tables in your worksheet, and you need to look up a certain value from the tables, how could you do this job in Excel? You can use the VLOOKUP function along with the INDIRECT function to lookup the values.

Let’s see the simple formula used to **dynamic lookup with INDIRECT Function 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)

[![Formulas for dynamic lookup with INDIRECT Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Formulas-for-dynamic-lookup-with-INDIRECT-Function.png)](https://geekexcel.com/excel-formulas-dynamic-lookup-with-indirect/formulas-for-dynamic-lookup-with-indirect-function/#main)<figcaption id="caption-attachment-20031">Formulas for dynamic lookup with INDIRECT Function</figcaption>
## General Formula:

- Use the below formula for dynamic lookup.

**=[VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)(A1,[INDIRECT](https://geekexcel.com/use-indirect-function-in-microsoft-excel-365-in-easy-ways/)(“text”),column)**

## Syntax Explanations:

- **VLOOKUP** – It helps to look up data in a range or table by row. Read more on the **[VLOOKUP Function](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)**.
- **INDIRECT** – In Excel, the [**INDIRECT Function**](https://geekexcel.com/use-indirect-function-in-microsoft-excel-365-in-easy-ways/) returns a valid reference from a given text string.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Text** – It is the criteria, which want to be lookup.
- **Column** – It returns the column number.

## Example:

- Now we are going to see how to lookup a value from multiple tables.
- Refer to the below image.
- Here, we will create two tables ranged from **Column B** to **Column C**.
- We will define a name for the values as Table1 and Table2.
- Then, apply the formula in the formula bar section.
- It will display the result in **Cell G3**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Example-68.png)<figcaption id="caption-attachment-20030">Example</figcaption>

## Closure:

So yeah guys, use this formula for lookup values from dynamic tables in Excel. Hope you like this post. Please share your **query** in the below comment box. We will assist you. Thank you so much for visiting our site!! To learn more, check out our website **[Geek Excel](https://geekexcel.com/)** and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Ahead:

- [**Excel Formulas to Find the Exact INDEX Match in Office 365!!**](https://geekexcel.com/excel-formulas-find-exact-index-match/)
- [**Excel Formulas to Find the Grades with VLOOKUP!!**](https://geekexcel.com/excel-formulas-find-grades-with-vlookup/)