Sheet1!$A$1:$E$5="有"改为Sheet1!$A$1:$E$5<>"无"补充:那么公式改为=INDEX(Sheet1!$A:$A,SMALL(IF(((Sheet1!$A$1:$E$5="有")+ISNUMBER(FIND("B",Sheet1!$A$1:$E$5)))*(Sheet1!$A$1:$E$1=A$1),ROW($A$1:$A$5),4^8),ROW($A1)))&""
