One Way
=INDEX(Sheet2!D:D,MATCH(Sheet1!A1,Sheet2!A:A,0))


"shauna" wrote:

I'm trying to write a formula that matches a value in cloumn A of sheet 1
with column a sheet 2 and return the value of column D of sheet 2 in sheet 1
when coulmn a in both sheets match. If they don't match I want a n/a to
return.