Moving/Copy data

[traderindia]

Hello,

Please open two Files attached herewith.

I want to copy data from second book.xls qty ' B' column to firstbook.xls qty 'B' column.

I can not regular copy/paste method, because in second book CODE column is in different order .

Thank you,

[dominicb]

Good morning traderindia

Please open two Files attached herewith.

No files attached.
Use the Manage Attachments button below your reply window to select which attachments to upload.

DominicB

[traderindia]

Attached

http://www.excelforum.com/attachment...irst-book.xlsx

http://www.excelforum.com/attachment...cond-book.xlsx

[traderindia]

Guys please help me out...

[royUK]

Use VLOOKUP

=VLOOKUP(A2,'[second book.xlsx]Sheet1'!$A$1:$B$6,2,FALSE)