Crossreferencing Data in Two Work Books

[TheDirtyDrunk]

Hello,
I have raw data in two different excel workbooks: 1 & 2. I'm trying to create a formula/macro that would search a column in each work book for identical values. The workbooks are broken down into three columns A B & C. If the cell value in column A-work book 1 is the same as any value in column a-workbook 2, then its adjacent value in column B is copied over from workbook 2 to workbook 1.
Please help me out with this, and if I didn't make it clear enough please let me know. Thank you.l

[aydeegee]

mis-read post

[aydeegee]

Hi DirtyDrunk

Welcome to the forum

Ignore the file attached to the last post - I was working on separate sheets, rather than separate workbooks.

The attached vlookups will work, as long as both workbooks are open.

Regards
Alasatir