Excel Formulas to Find the Two-Way Approximate Match Lookup!!
Tags: excelformula, excelformulas
Published: 2021-02-09 11:57:55

---
title: Excel Formulas to Find the Two-Way Approximate Match Lookup!!
published: true
date: 2021-02-05 05:32:25 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-find-two-way-approximate-match-lookup/
---

So far we have learned how to perform a lookup with the [**VLOOKUP function**](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/). In this tutorial, we are going to see how to **find the two-way approximate match lookup based on multiple criteria in Excel** by using the **INDEX** and **MATCH** functions. 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)

![Two-way approximate match lookup](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Two-way-approximate-match-lookup.png)<figcaption id="caption-attachment-21633">Two-way approximate match lookup</figcaption>

## General Formula:

You can use the below formula to perform multiple criteria lookup.

**=[INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(range,[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(B1,[IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)(data1=B2,data2),1),MATCH(B3,range,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/)**.
- **IF** – The Excel** [IF function](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)** return one value for a **[TRUE](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/)** result, and another for a **[FALSE](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/)** result.
- **Range** – It represents the input ranges.
- **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.

## Practical Example:

Refer to the below example image. Here we will show how to look up a value based on multiple criteria.

- First, we will enter the input ranges in **[Column](https://geekexcel.com/excel-office-365-columns/) B** to **Column E**.

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

- Then, apply the above-given formula to 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-2.png)<figcaption id="caption-attachment-21631">Enter the formula</figcaption>

- Finally, we will get the results as per the given below.

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

## Bottom-line:

From this guide, we have described the simple formulas used to find the **two-way approximate match lookup based on multiple criteria in Excel**. Hope you like it. If you have any **doubts** , feel free to share them with us. Keep learning on **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Related Articles:

- **[Excel Formulas to Lookup Table Based on Multiple Criteria with SUMIFS](https://geekexcel.com/excel-formulas-lookup-table-based-on-multiple-criteria-with-sumifs/)**
- **[Excel Formulas to Create a Two-way summary Count with COUNTIFS!!](https://geekexcel.com/excel-formulas-to-create-a-two-way-summary-count-with-countifs/)**