商品名称求和项:数量折前价折前合计折后价折后合计7#手摇国旗100=VLOOKUP(A2,[1]Sheet1!A:D,4,0)=B2*C2=VLOOKUP(A2,[1]Sheet1!A:G,7,0)=E2*B28#手摇国旗300=VLOOKUP(A3,[1]Sheet1!A:D,4,0)=B3*C3=VLOOKUP(A3,[1]Sheet1!A:G,7,0)=E3*B3A4/200克牛皮纸（100张）6=VLOOKUP(A4,[1]Sheet1!A:D,4,0)=B4*C4=VLOOKUP(A4,[1]Sheet1!A:G,7,0)=E4*B4A4会议记录本2=VLOOKUP(A5,[1]Sheet1!A:D,4,0)=B5*C5=VLOOKUP(A5,[1]Sheet1!A:G,7,0)=E5*B5U盘1=VLOOKUP(A6,[1]Sheet1!A:D,4,0)=B6*C6=VLOOKUP(A6,[1]Sheet1!A:G,7,0)=E6*B6艾美特CS30-RD2落地风扇1=VLOOKUP(A7,[1]Sheet1!A:D,4,0)=B7*C7=VLOOKUP(A7,[1]Sheet1!A:G,7,0)=E7*B7爱国者U360128G/U盘4=VLOOKUP(A8,[1]Sheet1!A:D,4,0)=B8*C8=VLOOKUP(A8,[1]Sheet1!A:G,7,0)=E8*B8爱可A4透明装订封皮PVC装订胶片5=VLOOKUP(A9,[1]Sheet1!A:D,4,0)=B9*C9=VLOOKUP(A9,[1]Sheet1!A:G,7,0)=E9*B9白猫蚊香/蚊香液檀香香型蚊香36=VLOOKUP(A10,[1]Sheet1!A:D,4,0)=B10*C10=VLOOKUP(A10,[1]Sheet1!A:G,7,0)=E10*B10办公杯4=VLOOKUP(A11,[1]Sheet1!A:D,4,0)=B11*C11=VLOOKUP(A11,[1]Sheet1!A:G,7,0)=E11*B11宝克5240涂刷两用型修正液6=VLOOKUP(A12,[1]Sheet1!A:D,4,0)=B12*C12=VLOOKUP(A12,[1]Sheet1!A:G,7,0)=E12*B12宝克880F中性笔0514=VLOOKUP(A13,[1]Sheet1!A:D,4,0)=B13*C13=VLOOKUP(A13,[1]Sheet1!A:G,7,0)=E13*B13报刊架1=VLOOKUP(A14,[1]Sheet1!A:D,4,0)=B14*C14=VLOOKUP(A14,[1]Sheet1!A:G,7,0)=E14*B14杯子2=VLOOKUP(A15,[1]Sheet1!A:D,4,0)=B15*C15=VLOOKUP(A15,[1]Sheet1!A:G,7,0)=E15*B15蓓尔蓝TTB-1504不锈钢垃圾铲5=VLOOKUP(A16,[1]Sheet1!A:D,4,0)=B16*C16=VLOOKUP(A16,[1]Sheet1!A:G,7,0)=E16*B16笔芯10=VLOOKUP(A17,[1]Sheet1!A:D,4,0)=B17*C17=VLOOKUP(A17,[1]Sheet1!A:G,7,0)=E17*B17标签贴6=VLOOKUP(A18,[1]Sheet1!A:D,4,0)=B18*C18=VLOOKUP(A18,[1]Sheet1!A:G,7,0)=E18*B18彩之印160G/A4牛皮纸100张5=VLOOKUP(A19,[1]Sheet1!A:D,4,0)=B19*C19=VLOOKUP(A19,[1]Sheet1!A:G,7,0)=E19*B19茶花整理箱透明、58L整理箱1=VLOOKUP(A20,[1]Sheet1!A:D,4,0)=B20*C20=VLOOKUP(A20,[1]Sheet1!A:G,7,0)=E20*B20晨光ASBN7114高粘度固体胶棒35g24=VLOOKUP(A21,[1]Sheet1!A:D,4,0)=B21*C21=VLOOKUP(A21,[1]Sheet1!A:G,7,0)=E21*B21晨光12#订书机ABS927491=VLOOKUP(A22,[1]Sheet1!A:D,4,0)=B22*C22=VLOOKUP(A22,[1]Sheet1!A:G,7,0)=E22*B22晨光ABS92725订书钉10=VLOOKUP(A23,[1]Sheet1!A:D,4,0)=B23*C23=VLOOKUP(A23,[1]Sheet1!A:G,7,0)=E23*B23晨光ADJ95786封箱胶带200y10=VLOOKUP(A24,[1]Sheet1!A:D,4,0)=B24*C24=VLOOKUP(A24,[1]Sheet1!A:G,7,0)=E24*B24晨光ADM94516按扣文件袋30=VLOOKUP(A25,[1]Sheet1!A:D,4,0)=B25*C25=VLOOKUP(A25,[1]Sheet1!A:G,7,0)=E25*B25晨光ADM95106A4便携式办公板夹4=VLOOKUP(A26,[1]Sheet1!A:D,4,0)=B26*C26=VLOOKUP(A26,[1]Sheet1!A:G,7,0)=E26*B26晨光ARP57501直液式签字笔144=VLOOKUP(A27,[1]Sheet1!A:D,4,0)=B27*C27=VLOOKUP(A27,[1]Sheet1!A:G,7,0)=E27*B27晨光ASBN7114高粘度固体胶棒35g60=VLOOKUP(A28,[1]Sheet1!A:D,4,0)=B28*C28=VLOOKUP(A28,[1]Sheet1!A:G,7,0)=E28*B28晨光ASS91420办公剪刀8=VLOOKUP(A29,[1]Sheet1!A:D,4,0)=B29*C29=VLOOKUP(A29,[1]Sheet1!A:G,7,0)=E29*B29晨光AWG97049高粘度液体胶125ml48=VLOOKUP(A30,[1]Sheet1!A:D,4,0)=B30*C30=VLOOKUP(A30,[1]Sheet1!A:G,7,0)=E30*B30晨光SPW34705铅笔4=VLOOKUP(A31,[1]Sheet1!A:D,4,0)=B31*C31=VLOOKUP(A31,[1]Sheet1!A:G,7,0)=E31*B31晨光YS-11多彩便利贴2=VLOOKUP(A32,[1]Sheet1!A:D,4,0)=B32*C32=VLOOKUP(A32,[1]Sheet1!A:G,7,0)=E32*B32晨光光敏印油4=VLOOKUP(A33,[1]Sheet1!A:D,4,0)=B33*C33=VLOOKUP(A33,[1]Sheet1!A:G,7,0)=E33*B33晨光清洁桶ALJ994114=VLOOKUP(A34,[1]Sheet1!A:D,4,0)=B34*C34=VLOOKUP(A34,[1]Sheet1!A:G,7,0)=E34*B34晨光中性笔迈腾AGP6550184=VLOOKUP(A35,[1]Sheet1!A:D,4,0)=B35*C35=VLOOKUP(A35,[1]Sheet1!A:G,7,0)=E35*B35晨光自粘性标签贴45=VLOOKUP(A36,[1]Sheet1!A:D,4,0)=B36*C36=VLOOKUP(A36,[1]Sheet1!A:G,7,0)=E36*B36大号信箱1=VLOOKUP(A37,[1]Sheet1!A:D,4,0)=B37*C37=VLOOKUP(A37,[1]Sheet1!A:G,7,0)=E37*B37得力30332封箱胶带2=VLOOKUP(A38,[1]Sheet1!A:D,4,0)=B38*C38=VLOOKUP(A38,[1]Sheet1!A:G,7,0)=E38*B38得力30413强力粘性双面胶27=VLOOKUP(A39,[1]Sheet1!A:D,4,0)=B39*C39=VLOOKUP(A39,[1]Sheet1!A:G,7,0)=E39*B39得力5342文件夹19=VLOOKUP(A40,[1]Sheet1!A:D,4,0)=B40*C40=VLOOKUP(A40,[1]Sheet1!A:G,7,0)=E40*B40得力5655网格拉链文件袋21=VLOOKUP(A41,[1]Sheet1!A:D,4,0)=B41*C41=VLOOKUP(A41,[1]Sheet1!A:G,7,0)=E41*B41得力5684_75mm档案盒10=VLOOKUP(A42,[1]Sheet1!A:D,4,0)=B42*C42=VLOOKUP(A42,[1]Sheet1!A:G,7,0)=E42*B42得力5901抽杆报告夹50=VLOOKUP(A43,[1]Sheet1!A:D,4,0)=B43*C43=VLOOKUP(A43,[1]Sheet1!A:G,7,0)=E43*B43得力7303液体胶水125ml24=VLOOKUP(A44,[1]Sheet1!A:D,4,0)=B44*C44=VLOOKUP(A44,[1]Sheet1!A:G,7,0)=E44*B44得力7550橡皮擦12=VLOOKUP(A45,[1]Sheet1!A:D,4,0)=B45*C45=VLOOKUP(A45,[1]Sheet1!A:G,7,0)=E45*B45得力78650书立(米白)(2片/付)3=VLOOKUP(A46,[1]Sheet1!A:D,4,0)=B46*C46=VLOOKUP(A46,[1]Sheet1!A:G,7,0)=E46*B46得力85608热水壶/保温壶1=VLOOKUP(A47,[1]Sheet1!A:D,4,0)=B47*C47=VLOOKUP(A47,[1]Sheet1!A:G,7,0)=E47*B47得力9863ES快干印台12=VLOOKUP(A48,[1]Sheet1!A:D,4,0)=B48*C48=VLOOKUP(A48,[1]Sheet1!A:G,7,0)=E48*B48得力NS062大号美工刀4=VLOOKUP(A49,[1]Sheet1!A:D,4,0)=B49*C49=VLOOKUP(A49,[1]Sheet1!A:G,7,0)=E49*B49得力S935HB高级书写铅笔1=VLOOKUP(A50,[1]Sheet1!A:D,4,0)=B50*C50=VLOOKUP(A50,[1]Sheet1!A:G,7,0)=E50*B50得力0012订书钉50=VLOOKUP(A51,[1]Sheet1!A:D,4,0)=B51*C51=VLOOKUP(A51,[1]Sheet1!A:G,7,0)=E51*B51得力0018回形针33=VLOOKUP(A52,[1]Sheet1!A:D,4,0)=B52*C52=VLOOKUP(A52,[1]Sheet1!A:G,7,0)=E52*B52得力0231起钉器10=VLOOKUP(A53,[1]Sheet1!A:D,4,0)=B53*C53=VLOOKUP(A53,[1]Sheet1!A:G,7,0)=E53*B53得力0314订书机8=VLOOKUP(A54,[1]Sheet1!A:D,4,0)=B54*C54=VLOOKUP(A54,[1]Sheet1!A:G,7,0)=E54*B54得力0371省力订书机1=VLOOKUP(A55,[1]Sheet1!A:D,4,0)=B55*C55=VLOOKUP(A55,[1]Sheet1!A:G,7,0)=E55*B55得力0522卷笔刀2=VLOOKUP(A56,[1]Sheet1!A:D,4,0)=B56*C56=VLOOKUP(A56,[1]Sheet1!A:G,7,0)=E56*B56得力1526语音型计算器2=VLOOKUP(A57,[1]Sheet1!A:D,4,0)=B57*C57=VLOOKUP(A57,[1]Sheet1!A:G,7,0)=E57*B57得力1542A语音型计算器2=VLOOKUP(A58,[1]Sheet1!A:D,4,0)=B58*C58=VLOOKUP(A58,[1]Sheet1!A:G,7,0)=E58*B58得力3724-DVD-R刻录光盘2=VLOOKUP(A59,[1]Sheet1!A:D,4,0)=B59*C59=VLOOKUP(A59,[1]Sheet1!A:G,7,0)=E59*B59得力520瞬间胶水（15G）2=VLOOKUP(A60,[1]Sheet1!A:D,4,0)=B60*C60=VLOOKUP(A60,[1]Sheet1!A:G,7,0)=E60*B60得力5342双强力文件夹18=VLOOKUP(A61,[1]Sheet1!A:D,4,0)=B61*C61=VLOOKUP(A61,[1]Sheet1!A:G,7,0)=E61*B61得力5505透明文件袋110=VLOOKUP(A62,[1]Sheet1!A:D,4,0)=B62*C62=VLOOKUP(A62,[1]Sheet1!A:G,7,0)=E62*B62得力5681档案盒25mm24=VLOOKUP(A63,[1]Sheet1!A:D,4,0)=B63*C63=VLOOKUP(A63,[1]Sheet1!A:G,7,0)=E63*B63得力5682档案盒35mm28=VLOOKUP(A64,[1]Sheet1!A:D,4,0)=B64*C64=VLOOKUP(A64,[1]Sheet1!A:G,7,0)=E64*B64得力5683档案盒55mm24=VLOOKUP(A65,[1]Sheet1!A:D,4,0)=B65*C65=VLOOKUP(A65,[1]Sheet1!A:G,7,0)=E65*B65得力6240直尺（40cm）1=VLOOKUP(A66,[1]Sheet1!A:D,4,0)=B66*C66=VLOOKUP(A66,[1]Sheet1!A:G,7,0)=E66*B66得力6600中性笔636=VLOOKUP(A67,[1]Sheet1!A:D,4,0)=B67*C67=VLOOKUP(A67,[1]Sheet1!A:G,7,0)=E67*B67得力71128洁净橡皮擦15=VLOOKUP(A68,[1]Sheet1!A:D,4,0)=B68*C68=VLOOKUP(A68,[1]Sheet1!A:G,7,0)=E68*B68得力7123强粘性固体胶(36g/支)14=VLOOKUP(A69,[1]Sheet1!A:D,4,0)=B69*C69=VLOOKUP(A69,[1]Sheet1!A:G,7,0)=E69*B69得力7739记事贴12=VLOOKUP(A70,[1]Sheet1!A:D,4,0)=B70*C70=VLOOKUP(A70,[1]Sheet1!A:G,7,0)=E70*B70得力77759剪刀2=VLOOKUP(A71,[1]Sheet1!A:D,4,0)=B71*C71=VLOOKUP(A71,[1]Sheet1!A:G,7,0)=E71*B71得力8551长尾夹50mm2=VLOOKUP(A72,[1]Sheet1!A:D,4,0)=B72*C72=VLOOKUP(A72,[1]Sheet1!A:G,7,0)=E72*B72得力8552长尾夹41mm7=VLOOKUP(A73,[1]Sheet1!A:D,4,0)=B73*C73=VLOOKUP(A73,[1]Sheet1!A:G,7,0)=E73*B73得力8553长尾夹32mm5=VLOOKUP(A74,[1]Sheet1!A:D,4,0)=B74*C74=VLOOKUP(A74,[1]Sheet1!A:G,7,0)=E74*B74得力8554长尾夹25mm7=VLOOKUP(A75,[1]Sheet1!A:D,4,0)=B75*C75=VLOOKUP(A75,[1]Sheet1!A:G,7,0)=E75*B75得力8555长尾夹19mm2=VLOOKUP(A76,[1]Sheet1!A:D,4,0)=B76*C76=VLOOKUP(A76,[1]Sheet1!A:G,7,0)=E76*B76得力8556长尾夹15mm2=VLOOKUP(A77,[1]Sheet1!A:D,4,0)=B77*C77=VLOOKUP(A77,[1]Sheet1!A:G,7,0)=E77*B77得力8931笔筒(黑色)2=VLOOKUP(A78,[1]Sheet1!A:D,4,0)=B78*C78=VLOOKUP(A78,[1]Sheet1!A:G,7,0)=E78*B78得力9863快干印台2=VLOOKUP(A79,[1]Sheet1!A:D,4,0)=B79*C79=VLOOKUP(A79,[1]Sheet1!A:G,7,0)=E79*B79得力9874快干印油2=VLOOKUP(A80,[1]Sheet1!A:D,4,0)=B80*C80=VLOOKUP(A80,[1]Sheet1!A:G,7,0)=E80*B80得力A5复写板20=VLOOKUP(A81,[1]Sheet1!A:D,4,0)=B81*C81=VLOOKUP(A81,[1]Sheet1!A:G,7,0)=E81*B81得力JL415双面棉纸胶带20=VLOOKUP(A82,[1]Sheet1!A:D,4,0)=B82*C82=VLOOKUP(A82,[1]Sheet1!A:G,7,0)=E82*B82得力S555大双头记号笔12=VLOOKUP(A83,[1]Sheet1!A:D,4,0)=B83*C83=VLOOKUP(A83,[1]Sheet1!A:G,7,0)=E83*B83得力S72签字笔72=VLOOKUP(A84,[1]Sheet1!A:D,4,0)=B84*C84=VLOOKUP(A84,[1]Sheet1!A:G,7,0)=E84*B84得力S856直液式水性笔12=VLOOKUP(A85,[1]Sheet1!A:D,4,0)=B85*C85=VLOOKUP(A85,[1]Sheet1!A:G,7,0)=E85*B85得力抽杆报告夹30=VLOOKUP(A86,[1]Sheet1!A:D,4,0)=B86*C86=VLOOKUP(A86,[1]Sheet1!A:G,7,0)=E86*B86得力切纸器1=VLOOKUP(A87,[1]Sheet1!A:D,4,0)=B87*C87=VLOOKUP(A87,[1]Sheet1!A:G,7,0)=E87*B87迪士比不干胶标签5=VLOOKUP(A88,[1]Sheet1!A:D,4,0)=B88*C88=VLOOKUP(A88,[1]Sheet1!A:G,7,0)=E88*B88封面本子2=VLOOKUP(A89,[1]Sheet1!A:D,4,0)=B89*C89=VLOOKUP(A89,[1]Sheet1!A:G,7,0)=E89*B89格力空调遥控器1=VLOOKUP(A90,[1]Sheet1!A:D,4,0)=B90*C90=VLOOKUP(A90,[1]Sheet1!A:G,7,0)=E90*B90公牛GN-403(3-3)排插8=VLOOKUP(A91,[1]Sheet1!A:D,4,0)=B91*C91=VLOOKUP(A91,[1]Sheet1!A:G,7,0)=E91*B91公牛GN-403-5米排插1=VLOOKUP(A92,[1]Sheet1!A:D,4,0)=B92*C92=VLOOKUP(A92,[1]Sheet1!A:G,7,0)=E92*B92公牛排插8=VLOOKUP(A93,[1]Sheet1!A:D,4,0)=B93*C93=VLOOKUP(A93,[1]Sheet1!A:G,7,0)=E93*B93光盘PP双面保护袋100张/包1=VLOOKUP(A94,[1]Sheet1!A:D,4,0)=B94*C94=VLOOKUP(A94,[1]Sheet1!A:G,7,0)=E94*B94黑色垃圾袋60=VLOOKUP(A95,[1]Sheet1!A:D,4,0)=B95*C95=VLOOKUP(A95,[1]Sheet1!A:G,7,0)=E95*B95黑色垃圾袋80×100CM手提式1350=VLOOKUP(A96,[1]Sheet1!A:D,4,0)=B96*C96=VLOOKUP(A96,[1]Sheet1!A:G,7,0)=E96*B96红色垃圾袋600=VLOOKUP(A97,[1]Sheet1!A:D,4,0)=B97*C97=VLOOKUP(A97,[1]Sheet1!A:G,7,0)=E97*B97记事本1=VLOOKUP(A98,[1]Sheet1!A:D,4,0)=B98*C98=VLOOKUP(A98,[1]Sheet1!A:G,7,0)=E98*B98键盘1=VLOOKUP(A99,[1]Sheet1!A:D,4,0)=B99*C99=VLOOKUP(A99,[1]Sheet1!A:G,7,0)=E99*B99金士顿128G存储盘2=VLOOKUP(A100,[1]Sheet1!A:D,4,0)=B100*C100=VLOOKUP(A100,[1]Sheet1!A:G,7,0)=E100*B100乐点垃圾拾取夹5=VLOOKUP(A101,[1]Sheet1!A:D,4,0)=B101*C101=VLOOKUP(A101,[1]Sheet1!A:G,7,0)=E101*B101联想4XA0E97775刻录机双接口1=VLOOKUP(A102,[1]Sheet1!A:D,4,0)=B102*C102=VLOOKUP(A102,[1]Sheet1!A:G,7,0)=E102*B102美家日记商用平板拖把60CM13=VLOOKUP(A103,[1]Sheet1!A:D,4,0)=B103*C103=VLOOKUP(A103,[1]Sheet1!A:G,7,0)=E103*B103美家日记商用平板拖把90CM10=VLOOKUP(A104,[1]Sheet1!A:D,4,0)=B104*C104=VLOOKUP(A104,[1]Sheet1!A:G,7,0)=E104*B104棉线拖把10=VLOOKUP(A105,[1]Sheet1!A:D,4,0)=B105*C105=VLOOKUP(A105,[1]Sheet1!A:G,7,0)=E105*B105南孚23A12V碱性电池1=VLOOKUP(A106,[1]Sheet1!A:D,4,0)=B106*C106=VLOOKUP(A106,[1]Sheet1!A:G,7,0)=E106*B106南孚5#电池30=VLOOKUP(A107,[1]Sheet1!A:D,4,0)=B107*C107=VLOOKUP(A107,[1]Sheet1!A:G,7,0)=E107*B107南孚7#电池30=VLOOKUP(A108,[1]Sheet1!A:D,4,0)=B108*C108=VLOOKUP(A108,[1]Sheet1!A:G,7,0)=E108*B108牛皮封面会议记录本30=VLOOKUP(A109,[1]Sheet1!A:D,4,0)=B109*C109=VLOOKUP(A109,[1]Sheet1!A:G,7,0)=E109*B109盘栽绿萝10=VLOOKUP(A110,[1]Sheet1!A:D,4,0)=B110*C110=VLOOKUP(A110,[1]Sheet1!A:G,7,0)=E110*B110普联TL-WDR7660千兆版无线路由器2=VLOOKUP(A111,[1]Sheet1!A:D,4,0)=B111*C111=VLOOKUP(A111,[1]Sheet1!A:G,7,0)=E111*B111齐心A4/70G多功能复印纸57=VLOOKUP(A112,[1]Sheet1!A:D,4,0)=B112*C112=VLOOKUP(A112,[1]Sheet1!A:G,7,0)=E112*B112签字笔2=VLOOKUP(A113,[1]Sheet1!A:D,4,0)=B113*C113=VLOOKUP(A113,[1]Sheet1!A:G,7,0)=E113*B113枪手750ml灭鼠/杀虫剂杀虫气雾剂24=VLOOKUP(A114,[1]Sheet1!A:D,4,0)=B114*C114=VLOOKUP(A114,[1]Sheet1!A:G,7,0)=E114*B114热水瓶塞子10=VLOOKUP(A115,[1]Sheet1!A:D,4,0)=B115*C115=VLOOKUP(A115,[1]Sheet1!A:G,7,0)=E115*B115日美中国共青团团徽团员徽章40=VLOOKUP(A116,[1]Sheet1!A:D,4,0)=B116*C116=VLOOKUP(A116,[1]Sheet1!A:G,7,0)=E116*B116睿志1T移动硬盘1=VLOOKUP(A117,[1]Sheet1!A:D,4,0)=B117*C117=VLOOKUP(A117,[1]Sheet1!A:G,7,0)=E117*B117赛卡诺三角会议台签100=VLOOKUP(A118,[1]Sheet1!A:D,4,0)=B118*C118=VLOOKUP(A118,[1]Sheet1!A:G,7,0)=E118*B118三星MU-PE1T0S移动硬盘1=VLOOKUP(A119,[1]Sheet1!A:D,4,0)=B119*C119=VLOOKUP(A119,[1]Sheet1!A:G,7,0)=E119*B119三益档案28510纸质档案盒10厘米50=VLOOKUP(A120,[1]Sheet1!A:D,4,0)=B120*C120=VLOOKUP(A120,[1]Sheet1!A:G,7,0)=E120*B120三益档案2856纸质档案盒6厘米50=VLOOKUP(A121,[1]Sheet1!A:D,4,0)=B121*C121=VLOOKUP(A121,[1]Sheet1!A:G,7,0)=E121*B121施美乐SM2474热水瓶1=VLOOKUP(A122,[1]Sheet1!A:D,4,0)=B122*C122=VLOOKUP(A122,[1]Sheet1!A:G,7,0)=E122*B122石材去污抛光除锈粉2=VLOOKUP(A123,[1]Sheet1!A:D,4,0)=B123*C123=VLOOKUP(A123,[1]Sheet1!A:G,7,0)=E123*B123收纳箱（大号）7=VLOOKUP(A124,[1]Sheet1!A:D,4,0)=B124*C124=VLOOKUP(A124,[1]Sheet1!A:G,7,0)=E124*B124手推车1=VLOOKUP(A125,[1]Sheet1!A:D,4,0)=B125*C125=VLOOKUP(A125,[1]Sheet1!A:G,7,0)=E125*B125鼠标1=VLOOKUP(A126,[1]Sheet1!A:D,4,0)=B126*C126=VLOOKUP(A126,[1]Sheet1!A:G,7,0)=E126*B126水管20=VLOOKUP(A127,[1]Sheet1!A:D,4,0)=B127*C127=VLOOKUP(A127,[1]Sheet1!A:G,7,0)=E127*B127塑料简易扫把10=VLOOKUP(A128,[1]Sheet1!A:D,4,0)=B128*C128=VLOOKUP(A128,[1]Sheet1!A:G,7,0)=E128*B128穗和30页无线胶装本15=VLOOKUP(A129,[1]Sheet1!A:D,4,0)=B129*C129=VLOOKUP(A129,[1]Sheet1!A:G,7,0)=E129*B129穗和A5木板夹9=VLOOKUP(A130,[1]Sheet1!A:D,4,0)=B130*C130=VLOOKUP(A130,[1]Sheet1!A:G,7,0)=E130*B130天章A4/A3-180G皮纹封面纸粉10=VLOOKUP(A131,[1]Sheet1!A:D,4,0)=B131*C131=VLOOKUP(A131,[1]Sheet1!A:G,7,0)=E131*B131天章A4/70g彩色大红复印纸1=VLOOKUP(A132,[1]Sheet1!A:D,4,0)=B132*C132=VLOOKUP(A132,[1]Sheet1!A:G,7,0)=E132*B132拖把壁挂夹11=VLOOKUP(A133,[1]Sheet1!A:D,4,0)=B133*C133=VLOOKUP(A133,[1]Sheet1!A:G,7,0)=E133*B133维达VS4491无芯三层大盘纸13=VLOOKUP(A134,[1]Sheet1!A:D,4,0)=B134*C134=VLOOKUP(A134,[1]Sheet1!A:G,7,0)=E134*B134维达牌盒装纸面巾100抽/盒/48盒3=VLOOKUP(A135,[1]Sheet1!A:D,4,0)=B135*C135=VLOOKUP(A135,[1]Sheet1!A:G,7,0)=E135*B135维克奇一次性纸杯80=VLOOKUP(A136,[1]Sheet1!A:D,4,0)=B136*C136=VLOOKUP(A136,[1]Sheet1!A:G,7,0)=E136*B136文骨8707双拉手提袋34=VLOOKUP(A137,[1]Sheet1!A:D,4,0)=B137*C137=VLOOKUP(A137,[1]Sheet1!A:G,7,0)=E137*B137无线网络发射器个1=VLOOKUP(A138,[1]Sheet1!A:D,4,0)=B138*C138=VLOOKUP(A138,[1]Sheet1!A:G,7,0)=E138*B138湘润洁吸水速干大号毛巾抹布10=VLOOKUP(A139,[1]Sheet1!A:D,4,0)=B139*C139=VLOOKUP(A139,[1]Sheet1!A:G,7,0)=E139*B139心相印RW210无芯卫生纸65=VLOOKUP(A140,[1]Sheet1!A:D,4,0)=B140*C140=VLOOKUP(A140,[1]Sheet1!A:G,7,0)=E140*B140一次性塑料杯220ml80=VLOOKUP(A141,[1]Sheet1!A:D,4,0)=B141*C141=VLOOKUP(A141,[1]Sheet1!A:G,7,0)=E141*B141壹滴水风辰双层玻璃杯300ml4=VLOOKUP(A142,[1]Sheet1!A:D,4,0)=B142*C142=VLOOKUP(A142,[1]Sheet1!A:G,7,0)=E142*B142樱之花五粒芳香球卫生球25=VLOOKUP(A143,[1]Sheet1!A:D,4,0)=B143*C143=VLOOKUP(A143,[1]Sheet1!A:G,7,0)=E143*B143用友A4平行记账凭证1000份/盒10=VLOOKUP(A144,[1]Sheet1!A:D,4,0)=B144*C144=VLOOKUP(A144,[1]Sheet1!A:G,7,0)=E144*B144真彩GR-111中性替芯2=VLOOKUP(A145,[1]Sheet1!A:D,4,0)=B145*C145=VLOOKUP(A145,[1]Sheet1!A:G,7,0)=E145*B145真彩RG-009通用替芯80=VLOOKUP(A146,[1]Sheet1!A:D,4,0)=B146*C146=VLOOKUP(A146,[1]Sheet1!A:G,7,0)=E146*B146整理箱6=VLOOKUP(A147,[1]Sheet1!A:D,4,0)=B147*C147=VLOOKUP(A147,[1]Sheet1!A:G,7,0)=E147*B147中佳0752皮面本12=VLOOKUP(A148,[1]Sheet1!A:D,4,0)=B148*C148=VLOOKUP(A148,[1]Sheet1!A:G,7,0)=E148*B148得力3872胶圈装订机2420=B149*C149=C149*092=E149*B149得力3853财务装订机铆管52mm2128=B150*C150=C150*092=E150*B150晨光AWG97039高粘度液体胶120ml27=B151*C151=C151*092=E151*B1511500整理箱特大号30100=B152*C152=C152*092=E152*B152得力5683档案盒55mm27212=B153*C153=C153*092=E153*B153得力63204党建档案盒55mm红5014=B154*C154=C154*092=E154*B154得力8561-1#黑色长尾夹50mm1317=B155*C155=C155*092=E155*B155得力8562-2#黑色长尾夹41mm1022=B156*C156=C156*092=E156*B156得力8563-3#黑色长尾夹32mm1014=B157*C157=C157*092=E157*B157麦储8G存储盘132=B158*C158=C158*092=E158*B158钥匙盘115=B159*C159=C159*092=E159*B159总计：=SUM(D2:D159)=SUM(F2:F159)纸质单据28张已核对无误后的合计金额=SUM(F2:F159)