## DEV Community is a community of 607,586 amazing developers

We're a place where coders share, stay up-to-date and grow their careers.

loading...

# How to use VLOOKUP to Match Two Tables with Excel Search Box? Andrews Originally published at geekexcel.com on ・3 min read

In the previous post, we have learned that how to create a search box with the 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

## Steps to get the lookup two tables with VLOOKUP:

Now we are going to look up two tables with the VLOOKUP function 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

• Then, we will select cell E4 , where we need to display the result.
• Click the “Formula” tab from the Ribbon. Select the formula tab

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

• Search for “VLOOKUP” then select to “Go” option. Search Vlookup

• The VLOOKUP function will appear in the below box and click on the “OK” button. Select Vlookup

• 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

• In the 2nd box, we will select the data range from the worksheet. Table Array

• The next box consists of column numbers , where the lookup value will available. Column Number

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

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

## 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!!

## Discussion (0) 