How do I merge 2 workbooks by comparing one column

[Guest]

I have 2 workbooks and each of them has 2 columns ITEM and DESCRIPTION. I
want to compare the item numbers and if the item nubers match want copy the
decription from workbook 2 to workbook 1 beside the description in workbook 1.

Thanks.

 

[Richard Buttrey]

On Wed, 25 Oct 2006 07:25:02 -0700, Sadiya Bilgrami <Sadiya

I have 2 workbooks and each of them has 2 columns ITEM and DESCRIPTION. I
want to compare the item numbers and if the item nubers match want copy the
decription from workbook 2 to workbook 1 beside the description in workbook 1.

Thanks.

In C2 of Wb1 (assuming field names are in A1:B1) enter

=IF(ISERROR(VLOOKUP(A2,[Book2]Sheet1!$A$1:$B$15,2,FALSE)),"",VLOOKUP(A2,[Book2]Sheet1!$A$1:$B$15,2,FALSE))

and copy down as required.

HTH


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________