統一發票 兌獎 (14652)

C2=MAX(IFERROR(OFFSET(E$6,MATCH(1,MMULT({1,1,1},N(RIGHT(G$4:G$6,{7,6,5,4,3})=RIGHT(B2,{7,6,5,4,3}))),),3),),SUMPRODUCT(N(G$2:G$6-B2=0)*H$2:H$6))