=IFERROR(VLOOKUP($B$2, OFFSET(INDIRECT(TEXT(A4 text, "#! 。 # # "& amp;; "! $E$2:$F$22 "), 일치 ("*TA50 1* "), 간접 (TEXT(A4," #! 。 # # "& amp;; "! A 1:A2000 "),,),, 2),," "