DEV Community

loading...

How to use VLOOKUP to Match Two Tables with Excel Search Box?

excelgeek profile image 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
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
Select the formula tab

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

Insert Function
Insert Function

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

Search Vlookup
Search Vlookup

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

Select Vlookup
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
Lookup Value

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

Table Array
Table Array

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

Column Number
Column Number

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

Result
Approximate Match

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

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

Read Ahead:

Discussion (0)

pic
Editor guide