不知道你说的是不是这样,比如两个工表SHeet1和sheet2的AB列数据进行比较。如果是,那你在sheet2的C2输入=IF(ISERROR(LOOKUP(1,0/((Sheet1!A$2:A$1069=A2)*(Sheet1!B$2:B$1069=Sheet2!B2)),Sheet1!C$2:C$1069)),"不一样","")向下填充。再在SHeet1的C2输入=IF(ISERROR(LOOKUP(1,0/((Sheet2!A$2:A$1069=A2)*(Sheet2!B$2:B$1069=Sheet2!B2)),Sheet2!C$2:C$1069)),"不一样","")向下填充。
温馨提示:答案为网友推荐,仅供参考