Merge Worksheet Columns

[Guest]

Please, how do I merge columns from two worksheets?
Example:
Worksheet 1 Worksheet 2
List Data1 List Data2
1 600 2 489
2 476 4 258
3 123 5 147
4 768
5 453
6 654

Merged Worksheet 3
List Data1 Data2
1 600
2 476 489
3 123
4 768 258
5 453 147
6 654

So I want to take worksheet 1 and merge it with worksheet 2 by "List" and create worksheet 3. Of course my real data involves 1,000's of values so it way too much to do by hand.

I seem to run in to this problem fairly often. Surely there is a reasonably easy solution.

Thanks,
Jeff

 

[Frank Kabel]

Hi
one way:
in your first sheet in C1 enter the formula
=IF(ISNA(MATCH(A1,'sheet2'!$A$1:$A$100,0)),"",VLOOKUP(A1,'sheet2'!$A$1:
$B$100,2,0))
and copy down

 

[Guest]

Hello Frank,

I copied and pasted as instructed, but Excel says there is a formula error. I don't know enough to spot the problem.

But thanks for trying,
Jeff

 

[Guest]

Hello,

I copied and pasted as instructed, but Excel said there was a formula error. I don't know enough to spot the problem.

But thanks for trying,
Jeff

 

[Frank Kabel]

Hi Jeff
formula works for me. Are you using the semicolon as delimiter (instead
of the coma?)