请问我有两个EXCEL表我想对比两个表格材料单价的差别,怎么做?答:两种做法 Sheet1 c2=IF(ISERROR(B2-INDEX(Sheet2!$B$2:$B$7,MATCH(Sheet1!A2,Sheet2!$A$2:$A$7,0))),"",B2-INDEX(Sheet2!$B$2:$B$7,MATCH(Sheet1!A2,Sheet2!$A$2:$A$7,0)))下拉 Sheet2 c2=IF(ISERROR(B1-VLOOKUP(A2,Sheet1!$A$2:$B$6,2,0)),"",B1-VLOOKUP(A2...