View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sadiya Bilgrami Sadiya Bilgrami is offline
external usenet poster
 
Posts: 1
Default How do I merge 2 workbooks by comparing one column

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.