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.

Exporting Data from Access to Excel

Microsoft Access is a Relational Database Management System(RDMS).which can organise information entity wise and provide efficient retrieval with the help of queries.

In this article, we will practice how to export data from Access to Excel. For that,we downloaded some dummy data from generatedata website.The dummy data has the following fields Name, Email, Company, OrganisationNumber, Phonenumber

Importing Data from Access to Excel
Employee Data

In the Ribbon,you can click External Tab and then click Excel under Export group. ( Don’t confuse with Excel under Import group. this option is for importing data from Excel to Access).

Now, It will open the Excel export wizard,and select the required options as per below image to export the data.

Exporting Data to Excel form Acess
Export Dialog to Excel

Finally, you will see a wizard confirming whether you want to save your export steps.

When to use Save Exports :

A simple case study to explain the save exports scenario. For suppose,If you are working as an analyst and handling Operational database which includes data regarding business activities.every day , if you want to forward the category wise data in the operational database to concerned manager.

write a query against the operational database as per the requirements from the concerned manager. and then,save export steps option. which will automate your exports by running macros.

Note :

    If you want to export data to existing workbook.please close the preferred workbook and then run the above steps. the name of workbook should be the name of the Access table or Query.