=IF(A1=Sheet2!$1:$9,Sheet2!D1,"-") -
the $ is to hold your range so when you cut and paste it doesnt move, but this will probably not work too well if you have different information in D but the same in A
that doesn't look at the whole range. it only matches it if A1 (sheet 1) = A1 (sheet2).
he needs it if A1 (sheet 1) matches anything in A (sheet 2)