彙整 指定購買號 (12024)

J2{=INDEX(B:B,SMALL(IF(OFFSET(A$2,,MATCH(I$2,C$1:F$1,)+1,22),ROW($2:$23),99),ROW(A1)))&""

K2=IF(J2="","",VLOOKUP(J2,B:F,MATCH(I$2,$1:$1,)-1,))