Just pull down the formula according to the file B04 you started.

=IFERROR(VLOOKUP($B$2，OFFSET(INDIRECT(TEXT(A4，" #！ . # # " & amp； "! $E$2:$F$22 "), matching ("*TA50 1* "), indirect (TEXT(A4," #! . # # " & amp； "! A 1:A2000 ")，)，)，2)，，"")