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

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?

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.

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.

Then we use fill handle to fill the list.

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