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