Using Vlookup and ImportRange to Pull data from one workbook to another

If you are new to Google spreadsheets. Then, it is bit different to use Vlookup to pull data from one workbook to another than in Microsoft Excel.Please read this article for those who need an introduction to ImportRange.

Case Study:

For suppose,if you have employee details and which you are using for marketing.Recently, a friend of yours has shared a file with you to check how many employee details has existed in your records. The file which you have is Employee Details for marketing and the file your friend shared with you is Check Details. For your reference have a look at below image.

Using Vlookup and ImportRange to pull data from one workbook to another
Using Vlookup and ImportRange to pull data from one workbook to another

Insert the below formula after adding the new column in the Employee Details for Marketing workbook. whenever there is match you see an employee name from another workbook. Use the filter to find out how many employees has matched.

=VLOOKUP(A2,
IMPORTRANGE(“1Xx133HsZNdyay9Fvwe1tTv5icfvDT0AVSRahCBs97Os”,”EmployeeData!$A$1:$F$100″),1,0)

In the above formula , A2 is lookup value , and then Lookup range , column index number.

For Lookup range, we are using ImportRange function to import data from another workbook.