兌換貨幣 以一元 (9543)

D2=LOOKUP(1,0/(MMULT(N(B2:C2=F$2:G$13),{1;1})=2),H$2:H$13)

另解=SUMPRODUCT((MMULT(N(B2:C2=F$2:G$13),{1;1})=2)*H$2:H$13)