1，=IFERROR(INDEX(数据!$B$2:$B$8,SMALL(IF(数据!$A$2:$A$8=资料!$A$4,ROW($A$1:$A$7),99),ROW(A2)+1))&"","")2.=IFERROR(VLOOKUP(资料!A4,数据!$B$2:$C$8,2,0),"")
