Vlookup Function with Multiple Tables

Using VLOOKUP () with multiple tables: We can also use VLOOKUP () function to extract a content/value by comparing 2 different tables in the same excel or different excel sheets. The left most column in both the tables must have similar data (In the below exampleEmployees Id is common in both the tables).

For example: If the user wants to search for the location of certain set of employees (Refer table 2), In the below example VLOOKUP function search’s for the Employee Id in Employee Location table to the Employee Id in the Employee Database table and returns the location of the employee.

Click on the table for a better view.

Table1: Employee Database

Vlookup Function

VLOOKUP() function is used to find a specific row in a large table of data and returns the respective column content. VLOOKUP() works by scanning the values in the left most column from top to bottom. Once it finds the content you're looking for, it can then retrieve other information from the same row.

Syntax: VLOOKUP(search_for, table_range, column_number, [range_lookup])

The first parameter, search_ for is the cell content that you're trying to find. The second parameter, table_range, is the rectangular grid of cells that contains all the data you're searching through. The third parameter is the column number from where the value is required and the last parameter range-lookup is used to search for an approximate match (specify True) or an exact match (specify False) .

Please refer to the below example, click on the below table for a better view.