指定型号 任一空 提取 (15426)

I4:K13{=OFFSET($A$3,SMALL(IF(MMULT(ISNUMBER(MATCH($B$3:$F$3,$J$3:$K$3,))*$B$4:$F$15,ROW(1:5)^0),ROW($1:$12),99),ROW(A1)),MATCH(I$3,$3:$3,)-1)&""

B4:F15格式化=COUNTIF($J$3:$K$3,B$3)*(B4>0)