vlookup公式运用

图号品名数量31FA-70350轴套122141HA-00101前围板7841HA-00112连接板-底中3241HA-00121连接板-底后2841HA-00131倾斜油缸支架（耳板）10341HA-00142前桥板19741HA-00151变速箱支架40641HA-00161发动机支架9841HA-0017096241HA-00222牛角板7241HA-00233后挡板041HA-00243后挡板041HA-00273后横梁支架7641HA-00281防滑板-左541HA-00291防滑板-右541HA-00302水箱支架18641HA-00330护顶架支架-后40041HA-00370连接板-上19641HA-01021护板-左前141HA-01021N护板2241HA-01032后桥2741HA-01040挡泥板-左1841HA-01050板041HA-01061脚踏板041HA-01070加强板-挡泥板内侧12241HA-01080支架-挡泥板内侧17841HA-01091板041HA-01102挂件041HA-01113挂件041HA-01150支架板-左油箱041HA-01162板041HA-01211内壁板041HA-01221注油管52141HA-01231螺母-放油口54741HA-01240螺母-油箱盖350041HA-02021护板5241HA-02021N护板7241HA-02040挡泥板-右041HA-02050板041HA-02101支架板-右油箱041HA-02112主控阀板7541HA-02131法兰-回油（3眼）2941HA-02202公用外壁板041HA-02212公用内壁板041HA-02221法兰-吸油4041HA-02232管-油位计86041HA-02240脚踏板041HA-02250板041HA-02262法兰盘10041HA-030113T/N后横梁2041HA-03022配重固定板(元宝)8641HA-03030板7241HA-060112T/N后横梁3041HC-02270轴24041HF-00201水箱支架041HF-00211水箱支架041HF-00222牛角板2041HF-00302消音器支架041HF-00350挂件041HF-010313T/F后桥141HF-010412T/F后桥-左041HF-01050挡泥板-左6541HF-01130板7841HF-01140板1341HF-01170板041HF-01200外壁板041HF-020313T/F后桥1841HF-020412T/F后桥-右041HF-02050挡泥板-右6541HF-060103T/F后横梁3541HF-070102T/F后横梁541HH-02131法兰-回油041HN-00030消音器支架041HN-00040消音器支架041HN-00220水箱支架31341HN-00320套163141HN-01062脚踏板-左立板041HN-01072板041HN-01080脚踏板-横板041HN-01090吊钩板-左041HN-01100脚踏板-丝块2孔24041HN-01110丝块-1孔65041HN-01210油箱内壁板-左2041HN-02250吊钩板-右041HN-03030支撑板-后横梁041HN-04011后桥1841HN-05120内壁板-右045HF-00120板045HF-00200消音器支架045HF-00211消音器支架045HF-00230后挡板045HF-00240后挡板045HF-00270板045HF-00300水箱支架045HF-00370板1845HF-01020护板2145HF-010313T/-7A后桥13445HF-01200外壁板-左2045HF-02020护板-右前2745HF-020303T/-7A后桥2045HF-02061脚踏板-右立板2745HF-02130支架-电瓶22245HF-02200外壁板2045HF-02211内壁板2045HF-02270板045HF-02280圆盘6045HF-030113T/-7A后横梁045HF-040302T/-7A后桥1845HF-050302T/-7A后桥3145HF-060102T/-7A后横梁245hn-00120板1845HN-00200水箱支架-左045HN-00210水箱支架-右045HN-00222水箱支座(牛头板)045HN-00231后盖板-左045HN-00240后盖板-右045HN-00251空滤支架045HN-00281消音器支架045HN-01110油箱外壁板-左045HN-01260吊钩板-左045HN-01270支架-滤清器045HN-02110油箱外壁板-右045HN-02120油箱内壁板-右045HN-02210护板-后4145HN-02260吊钩板-右045HN-03010后横梁-V板045HN-04110外壁板-左045HN-04120内壁板-左045HN-04210护板-后2745HN-04211后桥-左6445HN-05110外壁板-右045HN-05120内壁板-右045HN-06010吊钩板-左047HF-00120板047HF-00230047HF-00240047HF-00370板047HF-003806947HF-04090吊钩板-左13247HF-04120047HF-04200外壁板-左047HF-04210内壁板-左047HF-05120047HF-05200047HF-05210内壁板-右047HF-05250吊钩板-右17047HF-040301847HN-00230后挡板-右047HN-00240后挡板-左047HN-00250后挡板-左047HN-00270后挡板-右12248HF-00110板048HF-00230后挡板-左048HF-00240后挡板-右048HF-00251后挡板-左048HF-00261后挡板-右048HF-00350挂件048HF-00400板048HF-01020护板-左048HF-01031后桥-左048HF-02030后桥-右048HF-02130电瓶支架5148HF-03010后横梁548HF-04030后桥-左2748HF-05030后桥-右3348HF-06010后横梁17S017-100502螺栓0S035-061526带垫片的螺栓0S035-082026带垫片的螺栓0S037-102516带垫片的螺栓0S311-003040螺母-圆柱317S311-003050螺母-圆柱500S313-003020螺母-圆柱615S313-003025螺母-圆柱1250S313-003065螺母-圆柱602S313-004020螺母-圆柱605S315-003020螺母-圆柱860S315-003025螺母-圆柱960S351-202020螺母-圆柱913S351-304020丝块789S352-403020丝块-1孔230S355-306020丝块400S362-303020丝块-1孔1050S362-304030丝块-2孔62S362-407040丝块-2孔320S368-913040丝块-2孔391s594-000902卡子20441HH-02131法兰-回油27图号品名单价41HA-00151变速箱支架6.4041HA-00161发动机支架17.5241HA-00222牛角板27.2041HA-00233后挡板12.0041HA-00233N后挡板12.0041HA-00243后挡板12.0041HA-00243N后挡板12.0041HA-00302水箱支架12.8041HA-01021N护板288.6041HA-010313T/N后桥41HA-01040挡泥板-左179.4041HA-01050板25.6041HA-01061脚踏板23.2041HA-01091板16.8041HA-01102挂件2.6441HA-01113挂件10.4041HA-01150支架板-左油箱4.5641HA-01162板4.8041HA-01211内壁板181.6041HA-02021N护板358.0241HA-02040挡泥板-右179.4041HA-02050板43.2041HA-02101支架板-右油箱4.0041HA-02202公用外壁板277.6041HA-02212公用内壁板144.8041HA-02240脚踏板23.2041HA-02250板16.8041HN-040102T/N后桥179.4041HN-050102T/N后桥179.4041HA-001903.1241HA-010800.7841HF-00201水箱支架11.2041HF-00211水箱支架11.2041HF-00222牛角板28.0041HF-00302消音器支架12.8041HF-00350挂件10.4041HF-01050挡泥板-左179.4041HF-01200外壁板276.8041HF-02050挡泥板-右179.4041HN-00030消音器支架11.2041HN-00040消音器支架11.2041HN-01062脚踏板-左立板27.6041HN-01072板27.6041HN-01080脚踏板-横板30.7241HN-01090板16.8041HN-01201N外壁板276.8041HN-01210油箱内壁板-左181.6041HN-02201公用外壁板277.6041HN-02250板16.8045HF-00200消音器支架14.0045HF-00211消音器支架12.3245HF-00230后挡板8.0045HF-00240后挡板8.0045HF-00300水箱支架15.9245HF-01200外壁板268.6445HF-02061脚踏板-右立板27.6045HF-02200外壁板256.8845HF-02211内壁板174.0845HF-02270板19.3645HN-00200水箱支架-左12.2445HN-00210水箱支架-右12.3245HN-00222水箱支座(牛头板)57.3645HN-00231后盖板-左7.2045HN-00240后盖板-右8.4845HN-00251空滤支架8.0845HN-00281消音器支架2.4845HN-01110油箱外壁板-左268.4845HN-01260吊钩板-左27.9245HN-01270支架-滤清器3.2045HN-02110油箱外壁板-右270.0045HN-02120油箱内壁板-右174.0045HN-02260吊钩板-右27.92原油箱盖0.00大油箱盖0.00小油箱盖0.0041HF-01041182.5241HF-02041225.4245HF-021305.3841HA-010310.0041HN-00220水箱支架加强板4.7041HA-0037053.8245HF-01020280.4945HF-02020318.3245HF-01031279.3245HN-04110267.0945HN-04120175.5045HN-05110268.6145HN-05120173.4641HN-05120141.7547HF-0409019.4147HN-002509.4447HN-002409.4447HN-002306.0647HF-0525019.4141HA-001704.3041HA-00281防滑板-左25.0041HA-00291防滑板-右25.0041HA-00330护顶架支架-后4.5041HA-01070加强板-挡泥板内侧9.3641HA-02112主控阀板12.3041HA-02232管-油位计2.3141HC-02270轴6.8041HF-01130板3.9641HF-01140板3.4141HN-00320套2.8641HN-01100脚踏板-丝块2孔4.5741HN-01110丝块-1孔1.1045HF-02130支架-电瓶5