Excel Formulas to Get the Left Lookup with INDEX and MATCH!!
Tags: excelformula, excelformulas
Published: 2021-01-18 03:59:22

---
title: Excel Formulas to Get the Left Lookup with INDEX and MATCH!!
published: true
date: 2021-01-11 04:23:11 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-get-left-lookup-with-index-and-match/
---

Suppose you have a data range, and you want to know the id of the orders, and you want to get their relative product name from the left column. The normal **[VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)** function will not work. So how could you deal with this task in Excel? Here, I can introduce you to other formulas to solve this problem. Let’s see the steps to **get the left lookup with INDEX and MATCH functions 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)

[![Get Left Lookup](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Get-Left-Lookup.png)](https://geekexcel.com/?attachment_id=20854#main)<figcaption id="caption-attachment-20854">Get Left Lookup</figcaption>
## Generic Formula:

- To get the corresponding left value from the right specific data, the following formula can help you.

**=[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/)(A1,id,0))**

## 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 will 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/)**.
- **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.
- **Range** – It represents the input ranges in your worksheet.
- **ID** – It is the criteria that want to get the values.

## Example:

Refer to the below example. Here we will show how to get the details of the product based on its order id.

- First, we will give the input ranges in **Column B** to **Column E**.

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

- Here we need to find the details of the products of order id 1004.

![Criteria](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Criteria-4.png)<figcaption id="caption-attachment-20851">Criteria</figcaption>

- So, enter the formula in the **[cell](https://geekexcel.com/excel-cells-options/)** H3, and you can see the formula in 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/01/Enter-the-formula-3.png)<figcaption id="caption-attachment-20852">Enter the formula</figcaption>

- Now, we can get the result in the selected cell.

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

## Wrap-Up:

Hope you understood the simple steps to **get the left lookup of given data by using the INDEX and MATCH functions in Excel**. Found something that we’ve not covered? Stuck on something? Just drop it in the **comment** box below. Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)** and **[Excel Formulas](https://geekexcel.com/excel-formula/)!!**

### Related Articles:

- **[Excel Formulas to Get the Nth Matching Value Using VLOOKUP Function!!](https://geekexcel.com/excel-formula-nth-value-vlookup/)**
- **[Find the Largest Number in Excel Without using any Formula!!](https://geekexcel.com/find-largest-number-excel-without-using-any-formula/)**