If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Compare Worksheets
Hope someone can help with this what I'm trying to do is;
Compare a column on a worksheet in Book 1 (Say column A) to a column on sheet 1 in workbook 2 (Say Column C) If the value is found in book 2 I want to have the value of column D populate into book 1 column D The columns I am comparing are not identical in both books |
#2
|
|||
|
|||
Compare Worksheets
In D1 (oryour first row ... change A1 accordingly) of sheet 1:
=IF(ISNA(VLOOKUP(A1,'C:\Documents and Settings\John\Desktop\[Book2.xls]Sheet1'!$C:$D,2,0)),"",VLOOKUP(A1,'C:\Documents and Settings\John\Desktop\[Book2.xls]Sheet1'!$C:$D,2,0)) Change filepath as needed "dahench" wrote: Hope someone can help with this what I'm trying to do is; Compare a column on a worksheet in Book 1 (Say column A) to a column on sheet 1 in workbook 2 (Say Column C) If the value is found in book 2 I want to have the value of column D populate into book 1 column D The columns I am comparing are not identical in both books |
#3
|
|||
|
|||
Compare Worksheets
One way ..
With Book2.xls open In Book1.xls, Data assumed in row2 down Placed in D2: =IF(ISNA(MATCH(A2,[Book2]Sheet1!$C:$C,0)),"",INDEX([Book2]Sheet1!$D:$D,MATCH(A2,[Book2]Sheet1!$C:$C,0))) Copy down as far as required -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "dahench" wrote: Hope someone can help with this what I'm trying to do is; Compare a column on a worksheet in Book 1 (Say column A) to a column on sheet 1 in workbook 2 (Say Column C) If the value is found in book 2 I want to have the value of column D populate into book 1 column D The columns I am comparing are not identical in both books |
Thread Tools | |
Display Modes | |
|
|