merging data from one excel doc into another excel doc

[austin350s10]

Hello, I have 2 excel documents with the following structure:

Doc 1:
Column A(ID), Column B(empty)
2
1
3
1
2

Doc 2:
Column A(ID), Column B(data)
1 , data1
2 , data2
3 , data3

What I'm attempting to do is take the data from Column B in Doc2 and place it in Column B of Doc 1 where the ID from Column A matches between both documents. When completed I'd like Doc 1 to look this this:


Column A, Column(B)
2 ,data2
1 ,data1
3 ,data3
1 ,data1
2 ,data2

Any suggestions on how I can do this?

 

[Fluff]

You could use a Vlookup formula something like
=VLOOKUP(A2,'C:\MrExcel\[+Formulae.xlsx]Orders'!$A$2:$B$9,2,0)
change the path,filename & sheet name to suit