Excel Formulas to Find the Exact INDEX Match in Office 365!!
Tags: excelformula, excelformulas
Published: 2020-12-17 09:47:39

---
title: Excel Formulas to Find the Exact INDEX Match in Office 365!!
published: true
date: 2020-12-17 09:26:14 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-find-exact-index-match/
---

So far we have learned how to [Find the Approximate INDEX match in Excel](https://geekexcel.com/excel-formula-find-approximate-index-match/). In this tutorial, we will learn the simple formulas to **find the Exact INDEX Match in Excel**. Let’s see them below!! 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 to find the exact index match](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Formulas-to-find-the-exact-index-match.png)](https://geekexcel.com/excel-formulas-find-exact-index-match/formulas-to-find-the-exact-index-match/#main)<figcaption id="caption-attachment-19887">Formulas to find the exact index match</figcaption>
## General Formula:

- Here, we will show the simple formulas used to find the Exact INDEX match in Excel.

**=[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,range,FALSE),column)**

## Syntax Explanations:

- **INDEX** – The **[INDEX function](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)** returns the value at a given position in a range or array.
- **MATCH** – In Excel, 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/)**.
- **Range** – It represents the input values from the given worksheet.
- **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.
- **Values** – It represents the input ranges.
- **Column** – It returns the column number.

## Example:

- Now, we are going to find the exact match of the given criteria.
- Refer to the below image.
- Here we will enter the input values in **Column B** to **Column E**.
- Then, enter the formula in the formula bar section.
- Finally, we will get the result in **cell H4**.

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

## Conclusion:

Hope you understood the formulas to **find the exact INDEX match in Excel**. If you have any **doubt** regarding this article or have any other **questions** related to Excel, let me know in the **comments** section below. Thank you. 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 Smaller of Two Values!!**](https://geekexcel.com/wp-admin/post.php?post=19803&action=edit)
- **[Excel Formulas to Find the Nth Largest Value without Duplicates!!](https://geekexcel.com/wp-admin/post.php?post=19749&action=edit)**