求高手:excel中两列一组与另外两列一组数据对比答:使用vlookup函数即可,G4单元格输入=VLOOKUP(A4&B4,IF({1,0},$A$4:$A$14&$B$4:$B$14,$C$4:$C$14),2,)按CTRL+SHIFT+ENTER键结束 vlookup函数的用法你可以百度下 ,因为vlookup通常的做法是根据单列进行查找,这里是两列,所以先要用IF({1,0},$A$4:$A$14&$B$4:$B$14,$C$...
Excel如何比较两列数据并在新列中显示答:G2输入数组公式 =IF(ISERROR(INDEX(A$2:A$9,SMALL(IF(COUNTIF(C$2:C$11,A$2:A$9)=0,ROW(A$2:A$9)-1,8^8),ROW(A1))),"",INDEX(A$2:A$9,SMALL(IF(COUNTIF(C$2:C$11,A$2:A$9)=0,ROW(A$2:A$9)-1,8^8),ROW(A1)))以同按CTRL+SHIFT+回车 这三个键作为结束...