Excel Formulas to Find the Two-way Lookup with VLOOKUP Function!!
Tags: excel, excelformula, excelformulas
Published: 2021-02-09 05:52:41

---
title: Excel Formulas to Find the Two-way Lookup with VLOOKUP Function!!
published: true
date: 2021-02-07 16:17:06 UTC
tags: Excel,ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-find-two-way-lookup-with-vlookup/
---

Generally, the VLOOKUP function will help to look up the value from a table by a row. In this guide, we will discuss **how to find a Two-way lookup in Excel by using the VLOOKUP function?** 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)
## Generic Formula:

- To find the two-way lookup, you can use the below formula in Excel.

**=[VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)(lookup\_value,table,[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(column\_name,column\_headers,0),0)**

## Syntax Explanations:

- **VLOOKUP** – In Excel, the **[VLOOKUP function](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)** will help to lookup data in a range or table by row.
- **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/)**.
- **Lookup\_Value** -It represents the criteria that you want to be found.
- **Table** – It is the input data from your 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.

## Practical Example:

Refer to the below example. Here, we will show how to find the two-way lookup in Excel

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

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

- Then enter the 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-4.png)<figcaption id="caption-attachment-21696">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-5.png)<figcaption id="caption-attachment-21697">Result</figcaption>

## Wrap-Up:

In this short tutorial, we have described the simple formula used to **find the two-way lookup in Excel by using the VLOOKUP function**. If you feel this article is helpful then leave **feedback** in the below **comment** box. Thank you so much for visiting our site!! ![🙏](https://s.w.org/images/core/emoji/13.0.1/72x72/1f64f.png) Click here to know more about **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Related Articles:

- [**Excel Formula for Finding Vlookup Value Between Two Numbers!!**](https://geekexcel.com/excel-formula-for-finding-vlookup-value-between-two-numbers/)
- **[Excel Formulas to Calculate the Basic Rates with VLOOKUP!!](https://geekexcel.com/excel-formulas-find-basic-rates-with-vlookup/)**
- **[Formulas to Find the Two-Way Approximate Match Lookup!!](https://geekexcel.com/excel-formulas-find-two-way-approximate-match-lookup/)**