運費計算 依各城市 (14668)

D2=MAX(SUMPRODUCT(OFFSET(I$1:J$1,LOOKUP(1,0/FIND(G$2:G$99,B2)/FIND(H$2:H$99,B2)/(G$2:G$14>0),ROW($1:$98)),)*(ROUNDUP(C2,)^{0,1}-{0,1})),LOOKUP(1,0/FIND(G$2:G$99,B2)/FIND(H$2:H$99,B2)/(G$2:G$14>0),K$2:K$99))