Compare Worksheets

[Guest]

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

 

[Guest]

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

 

[Guest]

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