How do I merge 2 workbooks by comparing one column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sadiya Bilgrami - 25 Oct 2006 15:25 GMT

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.

Reply to this Message

Richard Buttrey - 25 Oct 2006 21:11 GMT

>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
__________________________

Reply to this Message