如数据在A2:E1000,待查询数据在F2:J2,在K2中输入公式:=IF(ISERROR(MATCH(F$2&G$2&H$2&I$2&J$2,A$3:A$1001&B$3:B$1001&C$3:C$1001&D$3:D$1001&E$3:E$1001,0)+2),"无此组数据","在第"&(MATCH(F$2&G$2&H$2&I$2&J$2,A$3:A$1001&B$3:B$1001&C$3:C$1001&D$3:D$1001&E$3:E$1001,0)+2)&"行") , 同时按下ENTER键,SHIFT键,和CTRL键.即可.示意图如下: