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