Hope someone can help as I keep finding similar answers but nothing quite fits my requirement.
希望有人可以提供帮助,因为我一直在寻找类似的答案,但没有什
I have 2 sheets, sheet 1 has 2 columns.....
我有2张,1张有2列......
A has ID's (long codes with no's, letters and symbols) B has a value corresponding to each of the ID'S
A具有ID(具有无,字母和符号的长代码)B具有对应于每个ID'的值
Sheet 2 has multiple Columns detailing items with corresponding ID's.
工作表2有多个列,详细说明具有相应ID的项目。
A has item description B has ID C is blank
A具有项目描述B,ID C为空白
I want to populate C with the relevant data from Sheet 1 column B into column C whenever the ID's match
我希望每当ID匹配时,用表1列B中的相关数据填充C到C列
Any help would be great as this could save me hours of work
任何帮助都会很棒,因为这可以节省我几个小时的工作量
1 个解决方案
#1
In sheet 1 I highlighted all of the data and selected I then named it table1. I then went to the top of Sheet 2 column B and chose fx VLOOKUP & selected Sheet 2 A2 as Lookup Value, table1 as Table Array, 2 as Col Index No. and False as the Range Lookup. My formula looked like this: VLOOKUP(A2,Table1,2,FALSE)
在表1中,我突出显示了所有数据并选中了我,然后将其命名为table1。然后我转到了Sheet 2 B列的顶部并选择了fx VLOOKUP并选择了Sheet 2 A2作为Lookup Value,table1作为Table Array,2作为Col Index No.而False作为Range Lookup。我的公式如下所示:VLOOKUP(A2,表1,2,FALSE)
#1
In sheet 1 I highlighted all of the data and selected I then named it table1. I then went to the top of Sheet 2 column B and chose fx VLOOKUP & selected Sheet 2 A2 as Lookup Value, table1 as Table Array, 2 as Col Index No. and False as the Range Lookup. My formula looked like this: VLOOKUP(A2,Table1,2,FALSE)
在表1中,我突出显示了所有数据并选中了我,然后将其命名为table1。然后我转到了Sheet 2 B列的顶部并选择了fx VLOOKUP并选择了Sheet 2 A2作为Lookup Value,table1作为Table Array,2作为Col Index No.而False作为Range Lookup。我的公式如下所示:VLOOKUP(A2,表1,2,FALSE)