Thursday 18 December 2014

How to Combine Data in 2 Table of different Worksheets?



How to Combine Data in 2 Table of different Worksheets?

Sample raw data in worksheet Sheet2:
Excel 2007


AB
1IdentityScore
226
337
458
575
697
7114
81256
91516
101612
111811
122010
13229
14236
15268
163012
173111
183321
193524
204123
214315
224512
23


Sheet2


And, in worksheet Sheet1:
Excel 2007


ABC
1IdentityNameScore
21Mr. Name 1
32Mr. Name 26
43Mr. Name 37
54Mr. Name 4
65Mr. Name 58
76Mr. Name 6
87Mr. Name 75
98Mr. Name 8
109Mr. Name 97
1110Mr. Name 10
1211Mr. Name 114
1312Mr. Name 1256
1413Mr. Name 13
1514Mr. Name 14
1615Mr. Name 1516
1716Mr. Name 1612
1817Mr. Name 17
1918Mr. Name 1811
2019Mr. Name 19
2120Mr. Name 2010

Sheet1


Worksheet Formulas
CellFormula
C2=IF(ISERROR(VLOOKUP(A2,Sheet2!A:B,2,)),"",VLOOKUP(A2,Sheet2!A:B,2,))

No comments:

Post a Comment