Excel Formulas to Find the Two-Way Lookup with INDEX and MATCH!!
Tags: excelformula, excelformulas
Published: 2021-02-10 08:02:35

---
title: Excel Formulas to Find the Two-Way Lookup with INDEX and MATCH!!
published: true
date: 2021-02-05 05:31:18 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-find-the-two-way-lookup-with-index-and-match/
---

In the previous post, we have seen how to find the two-way approximate match lookup in Excel? Similarly, here we are going to see the simple formula used to find the **two-way lookup with INDEX and MATCH function in Excel**. Let’s get started!! 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)

## General Formula:

- To look up the value in a table, you can use the below formula.

**=[INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(data,[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(value,rows,1),MATCH(value,columns,1))**

## Syntax Explanations:

- **INDEX** – In Excel, the **[INDEX function](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)** will return the value at a given position in a range or array.
- **MATCH** – This function helps to locate the position of a lookup value in a row, column, or table. Read more on the **[MATCH function.](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)**
- **Data** – It represents the input values in the range.
- **Values** – It is the criteria that want to be found.
- **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.

## Example:

Let’s consider the below example image. Here we will show a simple example for your reference.

- First, we will give the input values in **Column B** to **Column G**.

![Input Ranges](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Input-Ranges-1.png)<figcaption id="caption-attachment-21658">Input Ranges</figcaption>

- Then, enter the above-given formula into the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section.

![Enter the formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Enter-the-formula-3.png)<figcaption id="caption-attachment-21659">Enter the formula</figcaption>

- Finally, we will get the result in the selected cell.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Result-3.png)<figcaption id="caption-attachment-21660">Result</figcaption>

## Verdict:

From this short tutorial, we have described the simple formula used to find the **two-way lookup value with the INDEX and MATCH functions in Excel**. Please state your **query** to the below comment section. Thank you so much for visiting our site. Continue learning on **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Related Articles:

- **[Excel Formulas to Lookup Multiple Criteria with INDEX and MATCH!!](https://geekexcel.com/excel-lookup-multiple-criteria-with-index-and-match/)**
- **[Excel Formulas to Get the Nth Matching Value With INDEX Function!!](https://geekexcel.com/excel-formulas-nth-matching-value-with-index/)**