統一發票 兌獎 (11839)

J2利用表列 1{=IFERROR(VLOOKUP(I2,C$4:D$5,2,),)+MAX((RIGHT(C$6:C$8,{8,7,6,5,4,3})=RIGHT(I2,{8,7,6,5,4,3}))*TRANSPOSE(G$3:G$8))

利用表列 1 {=SUMIF(C:C,I2,D:D)+MAX((RIGHT(C$6:C$8,{8,7,6,5,4,3})=RIGHT(I2,{8,7,6,5,4,3}))*TRANSPOSE(G$3:G$8))

利用表列 2 {=MAX((RIGHT(F$15:F$19,{8,7,6,5,4,3})=RIGHT(I2,{8,7,6,5,4,3}))*G$15:L$19)