Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

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.

Leave a Reply

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