如何将数据从一张表导入另一张 [英] How to import data from one sheet to another
问题描述
例如。
sheet 1 sheet2
ID名称价格ID名称价格
xyz包20 abc 15
abc夹克15 xyz 20
所以有一种方法可以在表1中添加名称中的名称,其中表1中的ID=表2中的ID ?
没有应用和粘贴当然
谢谢
p> VLookup
您可以使用简单的VLOOKUP公式来实现。我将数据放在同一张表中,但也可以引用其他工作表。对于价格栏,只需将最后一个值从2更改为3,就像您参考矩阵A2:C4的第三列一样。
外部参考
要引用相同工作簿的单元格,请使用以下模式:
< Sheetname>!<单元格>
示例:
Table1!A1
不同工作簿使用此模式:
[< Workbook_name>]< Sheetname>!<电池>
示例:
[MyWorkbook] Table1!A1
I have two different work sheets in excel with the same headings in in all the row 1 cells(a1 = id, b1 = name, c1 = price). My question is, is there a way to import data(like the name) from 1 worksheet to the other where the "id" is the same in both worksheets.
eg.
sheet 1 sheet2
ID Name Price ID Name Price
xyz Bag 20 abc 15
abc jacket 15 xyz 20
So is there a way to add the "Name" in sheet 1 the "Name" in sheet 2 where the "ID" in sheet 1 = "ID" in sheet 2?
Without coping and pasting of course Thanks
VLookup
You can do it with a simple VLOOKUP formula. I've put the data in the same sheet, but you can also reference a different worksheet. For the price column just change the last value from 2 to 3, as you are referencing the third column of the matrix "A2:C4".
External Reference
To reference a cell of the same Workbook use the following pattern:
<Sheetname>!<Cell>
Example:
Table1!A1
To reference a cell of a different Workbook use this pattern:
[<Workbook_name>]<Sheetname>!<Cell>
Example:
[MyWorkbook]Table1!A1
这篇关于如何将数据从一张表导入另一张的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!