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