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