查找对应行的数据 (9722)

B3:C19=OFFSET(K$1,MATCH(LOOKUP("嫻",$A$3:$A3),$J:$J,)+ROW(A1)-LOOKUP(1,0/($A$3:$A3<>""),ROW($1:1))-1,)

另解=INDEX(K:K,MATCH(LOOKUP("座",$A$1:$A3),$J:$J,)+ROW()-MATCH("座",$A$1:$A3))