已知数据存在一对多的关系,当有一对数据,如何用excel判断这对数据是否是...答:假设你的数据值最大为999 你在表2的C1输入公式:=IF(ISNUMBER(MATCH(TEXT(A1,"000")&TEXT(B1,"000"),TEXT(Sheet1!A$1:A$1000,"000")&TEXT(Sheet1!B$1:B$1000,"000"),0)),"能对应","不对应")数组公式,Ctrl+Shift+Enter三键结束 下拉就可以 ...
excel一对多查找要怎么实现?答:$100)-5,),Sheet2!$P$6:$P$100),INT(ROW(A7)/7)),"")ctrl+shift+回车,下拉 F5:=IFERROR(INDEX((Sheet2!$M:$M,Sheet2!$O:$O),SMALL(IF(Sheet2!$P$6:$P$100=$D5,ROW($6:$100)),COUNTIF($D$5:$D5,$D5)),1,COLUMN(A1)),"")ctrl+shift+回车,右拉,下拉 ...