View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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