try~ declare @a table( Txt nvarchar(100) ) insert into @a values(N'培林5205ZZ8只')...
J2:=INDEX(A1:G1,SUMPRODUCT(($B$3:$G$12=$J$1)X(COLUMN($B$3:$G$12))))或=INDEX(A1:G1...