"Bob Phillips" wrote...
On sheet2, use a helper column, say M

M2: =MATCH(B2,Sheet1!$E:$E,0)
N2: =IF(ISNUMBER(M2),IF(AND(INDEX(Sheet1!$F:$F,M2)=C2, INDEX(Sheet1!$G:$G,M2)=D2,
INDEX(Sheet1!$H:$H,M2)=E2,INDEX(Sheet1!$I:$I,M2)= F2),"Match","No match"))
....

FTHOI, a single formula alternative.

N2:
=IF(COUNT(M2),IF(COUNT(INDEX(1/(INDEX(Sheet1!$F:$I,M2,0)=C2:F2),
1,0))=4,"full","partial")
&" address","no phone #")&" match"