-
最佳答案:=IF(SUM(--NOT(ISERROR(MATCH(b1&c1,sheet2!b$1:b$5&c$1:c$5,)))),"重复","")数组公式以ctrl+
-
最佳答案:C1输入=if(countif(A:A,b1),b1,"")下拉与B列一样的行数,此列为二行都有的.D1输入=if(countif(A:A,b1),"",b1)
-
最佳答案:假设第二表为Sheet2则在Sheet1的D2输入=vlookup(A2,Sheet2!A:C,3,0)下拖填充即可
-
最佳答案:C2=VLOOKUP(A2&B2,IF({1,0},Sheet1!$A$2:$A$16&Sheet1!$B$2:$B$16,Sheet1!$C$2:$C$16)