How to Import Data From One Sheet To Another in Excel?

Date:2021-12-9 Author:Sandra

The following two pictures are Shee1 and Sheet2 from the same Excel workbook. Now we need to import the English scores in Sheet 2 into Sheet 1, but it can be seen from the figure that the names of Table 1 and Table 2 do not correspond one-to-one. So, how to quickly import data?

How to Import Data From One Sheet To Another in Excel?
How to Import Data From One Sheet To Another in Excel?

Now we insert a new row to prepare for the English score. Click the button of Insert Function like below. Select the VLOOKUP and hit ok.

How to Import Data From One Sheet To Another in Excel?

Choose cell A2 in Sheet 1 as Lookup value; choose rows A and B as Table array; enter 2 in the third box and 0 in the last one.

How to Import Data From One Sheet To Another in Excel?
How to Import Data From One Sheet To Another in Excel?

Then we use fill handle to fill the list.

How to Import Data From One Sheet To Another in Excel?

Well, that’s all about today’s tutorial. Hope this can be helpful to you.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

One response to “How to Import Data From One Sheet To Another in Excel?”

  1. I have not checked in here for a while since I thought it was getting boring, but the last several posts are good quality so I guess I?¦ll add you back to my daily bloglist. You deserve it my friend 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *