排列彙整 (13572)

G2:J4=VLOOKUP($F2,OFFSET($B$1:$C$1,MATCH(G$1,$C:$C,),,3),2,)

另解=SUMPRODUCT((LOOKUP(ROW($1:$16),ROW($1:$16)/ISERR(-$C$1:$C$16),$C$1:$C$16)=G$1)*($B$1:$B$16=$F2)*N(+$C$1:$C$16))