取多个同值的对应值 (9337)

一般用 C2{=INDEX(B:B,SMALL(IF(A$2:A$9=0,ROW($2:$9),99),ROW(A1)))&""

一定用VLOOKUP  C2{=IFERROR(VLOOKUP(ROW(A1),IF({1,0},COUNTIF(OFFSET(A$2,,,ROW($1:$8)),0),B$2:B$9),2,),"")