Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to compare 2 worksheets... | Excel Discussion (Misc queries) | |||
compare worksheets | Excel Discussion (Misc queries) | |||
Compare two worksheets | New Users to Excel | |||
Compare worksheets | Excel Worksheet Functions | |||
How do I compare in between two worksheets? | Excel Worksheet Functions |