Excel问题 对比两个Sheet各两列数据,两两对应,才为止确(如黄色),如何...答:按照你的表做个Demo:Sheet2:Sheet1:在Sheet1的JKL输入公式:J2:=OFFSET(B$1,SMALL(IF(ISNA(MATCH(H$2:H$1000&B$2:B$1000,Sheet2!E$2:E$1200&Sheet2!F$2:F$1200,0)),65535,ROW($2:$1000)-1),ROW(A1)),)&""K2:=OFFSET(H$1,SMALL(IF(ISNA(MATCH(H$2:H$1000&B$2:B$...