Replacing IF /AND formula with VLOOKUP

Ok so this formula does work but breaks after to many if and statements. How can I preform the same task just in a better way?

=IF(sheet1!D2=sheet2!$A$3,AND(sheet1!E2=sheet2!$C$1,sheet2!$C$3)
,IF(sheet1!D2=sheet2!$A$3,AND(sheet1!E2=sheet2!$D$1,sheet2!$D$3)
,IF(sheet1!D2=sheet2!$A$3,AND(sheet1!E2=sheet2!$E$1,sheet2!$E$3)
,IF(sheet1!D2=sheet2!$A$3,AND(sheet1!E2=sheet2!$F$1,sheet2!$F$3)
,IF(sheet1!D2=sheet2!$A$4,AND(sheet1!E2=sheet2!$C$1,sheet2!$C$4)
,IF(sheet1!D2=sheet2!$A$4,AND(sheet1!E2=sheet2!$D$1,sheet2!$D$4)
,IF(sheet1!D2=sheet2!$A$4,AND(sheet1!E2=sheet2!$E$1,sheet2!$E$4)
,IF(sheet1!D2=sheet2!$A$4,AND(sheet1!E2=sheet2!$F$1,sheet2!$F$4)
,IF(sheet1!D2=sheet2!$A$5,AND(sheet1!E2=sheet2!$C$1,sheet2!$C$5)
,IF(sheet1!D2=sheet2!$A$5,AND(sheet1!E2=sheet2!$D$1,sheet2!$D$5)
,IF(sheet1!D2=sheet2!$A$5,AND(sheet1!E2=sheet2!$E$1,sheet2!$E$5)
,IF(sheet1!D2=sheet2!$A$5,AND(sheet1!E2=sheet2!$F$1,sheet2!$F$5)))))))))))))

Thanks :P