依尋找列找 1 顯示列值 (9176)

H2{=INDEX(INDIRECT(CHAR(64+F$5)&":"&CHAR(64+F$5)),SMALL(IF(OFFSET(A$1:A$9,,F$2-1)=1,ROW($1:$9),99),ROW(A1)))&""

另解{=INDEX(OFFSET(A:A,,F$5-1),SMALL(IF(OFFSET(A$1:A$9,,F$2-1)=1,ROW($1:$9),99),ROW(A1)))&""