e2=INDIRECT("C"&MIN(IF(COUNTIF($A$2:$A$99,$C2:$C$99),ROW(2:$99),)))f2=VLOOKUP(E2,$A$2:$B$9,2) 想去掉#REF显示的方法=IF(ISERR(INDIRECT("C"&MIN(IF(COUNTIF($A$2:$A$99,$C2:$C$99),ROW(2:$99),)))),"",INDIRECT("C"&MIN(IF(COUNTIF($A$2:$A$99,$C2:$C$99),ROW(2:$99),)))) =IF(ISERROR(VLOOKUP(G2,$A$2:$B$9,2)),"",VLOOKUP(G2,$A$2:$B$9,2)...
|