Thread
:
Match help
View Single Post
#
7
Mrbanner
Posts: n/a
Match help
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))))
Reply With Quote