How to use VLOOKUP to Match Two Tables with Excel Search Box?
Tags: excelpreface, excelbasics, exceltutorials, vlookuptwotableswith
Published: 2021-02-09 08:45:57

---
title: How to use VLOOKUP to Match Two Tables with Excel Search Box?
published: true
date: 2021-02-05 12:27:17 UTC
tags: ExcelPreface,ExcelBasics,ExcelTutorials,Vlookuptwotableswith
canonical_url: https://geekexcel.com/how-to-use-vlookup-to-match-two-tables-with-excel-search-box/
---

In the previous post, we have learned that **[how to create a search box with the VLOOKUP function?](https://geekexcel.com/how-to-create-search-box-vlookup-function/)** Similarly, here we are going to discuss the simple way to **lookup two tables in Excel by using the VLOOKUP function**. Let’s jump 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)
## Steps to get the lookup two tables with VLOOKUP:

Now we are going to look up two tables with the **[VLOOKUP function](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)** in Excel by using the search box. Refer to the below example.

- First, we will enter the input values as shown below here we need to find the region of the given state.

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

- Then, we will select **cell E4** , where we need to display the result.
- Click the **“Formula”** tab from the  [**Ribbon**](https://geekexcel.com/ribbon-keyboard-shortcut-keys-in-microsoft-excel-365/).

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

- Here, we will select the **“Insert Function”** option.

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

- Search for **“VLOOKUP”** then select to **“Go”** option.

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

- The **VLOOKUP function** will appear in the below box and click on the **“OK”** button.

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

- Now, it will open the **“Function Arguments”** window. In the **1st box** , you need to enter the **lookup value** which you want to be found.

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

- In the **2nd box,** we will select the data range from the worksheet.

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

- The next box consists of **column numbers** , where the lookup value will available.

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

- In the last box, type **“False”** to search the **exact matching value** **[True= Approximate match],** and click the **“Ok”** button.

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

- Finally, drag-down the result cell, it will display the results in all cells with a matching value.

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

## Closure:

From this chapter, you have clearly understood the simple steps used to **find the lookup value from two tables in Excel based on the VLOOKUP function**. 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 for Visiting **[Geek Excel](https://geekexcel.com/)!!**

### Read Ahead:

- **[Excel Formulas to Find the Two-Way Approximate Match Lookup!!](https://geekexcel.com/excel-formulas-find-two-way-approximate-match-lookup/)**
- **[How to use VLOOKUP to Create a Search Box? ~ Complete Guide](https://geekexcel.com/how-to-create-search-box-vlookup-function/)**