查找 户主姓名 (10100)

同村同名 有誤=LOOKUP(1,0/(MATCH(J2&K2,B$2:B$8&C$2:C$8,)>=ROW($1:$7))/(F$2:F$8="户主"),C$2:C$8)

户联系电话 同戶須同號=INDEX(C:C,MATCH(LOOKUP(1,0/(B$2:B$8=J2)/(C$2:C$8=K2),G$2:G$8),G:G,))

户联系电话 同戶須同號=LOOKUP(1,0/FREQUENCY(SUMIFS(G:G,B:B,J2,C:C,K2),G$2:G$8),C$2:C$8)