=IF(ROW()>COUNTIF($A$1:$A$11,$D$2),"",LOOKUP(ROW(),MMULT(N(ROW($1:$11)>COLUMN(A:K)),N(ISNUMBER(SEARCH(D$2,$A$1:$A$11))))+1,$B$1:$B$11))
ROW($1:$11)>COLUMN(A:K) 这中间必须相等吗? ROW($1:$100)>COLUMN(A:K)就出错
A-K就是1-11把你的场景发图片上来,否则不好解释,无法根据需求帮你改。