| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I merge 2 workbooks by comparing one column
On Wed, 25 Oct 2006 07:25:02 -0700, Sadiya Bilgrami <Sadiya
wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Combining workbooks with some variable field names | Excel Discussion (Misc queries) | |||
| Comparing Cells and Displaying Data | Excel Worksheet Functions | |||
Linear Mode
