Select Sheet1 D1:D20

now enter this formula
=IF(AND(A1:A20=Sheet2!A1:A20),Sheet2!D1:D20,"")

not just enter, use Ctrl + Shift + Enter

On Oct 22, 12:06*am, KS wrote:
How can I do the following

If 'Sheet 1'A1:A20 = 'Sheet2'A1:A20 then return value from 'Sheet2'D1:D20
into 'Sheet1' D1:D20
--
KS