Works great thanks
=IF(OR(D2="",J2=""),"",
IF(ISNA(MATCH(1,(Sheet1!$D$2:$D$8000=D2)*(Sheet1!$ J$2:$J$8000=J2),0)),"",

INDEX(Sheet1!$AG$2:$AG$8000,
MATCH(1,(Sheet1!$D$2:$D$8000=D2)*(Sheet1!$J$2:$J$8 000=J2),0))))