trying to use LOOKUP. if I want to compare Column A of sheet1 to column A of sheet 2 and if column A is the same for both sheets move data from Column D on sheet2 to Column D on sheet1.

Thanks