You're welcome !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Mrbanner" wrote in message
oups.com...
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))))