合併格取值 依代号 名称 (9195)

G2:J13=SUMPRODUCT((LOOKUP(ROW($2:$999),ROW($2:$999)/($B$2:$B$999<>""),$B$2:$B$999)=G$1)*ISNUMBER(FIND($F2,$C$2:$C$999))*$D$2:$D$999)