Spreadsheet: 153664d1335994066-vlookup-from-2-cells-test-file-vlookup
Sheet: B&C Cost Figures

 |  | Product | Batch |  |  |  |  |  |  |  | Price
A130210042 | CTP-Mumbai | YCHEPCDECX0XX | LFUJI | DEVELOPER FOR CTP PLATES | -650 | 0 |  |  | -650 | 0 | 0
 |  |  | LTECH |  | -100 | 0 |  |  | -100 | 0 | 0
 |  |  |  | DEVELOPER FOR CTP PLATES Total | -750 | 0 |  |  | -750 | 0 | 0
 |  | YCHEPCGMCX0XX | LTECH | FINISHING GUM FOR CTP PLATES | -180 | -17065.35 |  |  | -180 | -17065.35 | 94.80750000000002
 |  |  |  | FINISHING GUM FOR CTP PLATES Total | -180 | -17065.35 |  |  | -180 | -17065.35 | 94.80750000000002
 |  | YCHEPCRECX0XX | LFUJI | REPLENSIHER FOR CTP PLATES | -1600 | 0 |  |  | -1600 | 0 | 0
 |  |  | LTECH |  | -300 | 0 |  |  | -300 | 0 | 0
 |  |  |  | REPLENSIHER FOR CTP PLATES Total | -1900 | 0 |  |  | -1900 | 0 | 0
 |  | YFUJCTPR000XX | (blank) | FUJI VIOLET POLYMER PLATE REPLENISHER | -300 | 0 | 300 | 0 | 0 | 0 | 0
 |  |  |  | FUJI VIOLET POLYMER PLATE REPLENISHER Total | -300 | 0 | 300 | 0 | 0 | 0 | 0
 |  | YFUJDEVX3WSXX | (blank) | FUJI LP-D3WS DEVELOPER. | -200 | 0 | 200 | 0 | 0 | 0 | 0
 |  |  |  | FUJI LP-D3WS DEVELOPER. Total | -200 | 0 | 200 | 0 | 0 | 0 | 0
 |  | YNNVCOLC030FH | (blank) | COLORMAN CTP PLATE | -15000 | -1081267.95 | 15000 | 1081267.95 | 0 | 0 | 72.08453
 |  |  |  | COLORMAN CTP PLATE Total | -15000 | -1081267.95 | 15000 | 1081267.95 | 0 | 0 | 72.08453
 |  | YNNVGMNC030AC | (blank) | GEOMAN CTP PLATE | -5000 | -372169.19 | 5000 | 372169.19 | 0 | 0 | 74.433838
 |  |  |  | GEOMAN CTP PLATE Total | -5000 | -372169.19 | 5000 | 372169.19 | 0 | 0 | 74.433838
 |  | YPLTCOLCXX0FH | [NAME] | COLORMAN CTP PLATE | -65000 | -4683202.29 |  |  | -65000 | -4683202.29 | 72.049266
 |  |  | LVST |  | -6500 | -466623.2 |  |  | -6500 | -466623.2 | 71.78818461538461
 |  |  |  | COLORMAN CTP PLATE Total | -71500 | -5149825.49 |  |  | -71500 | -5149825.49 | 72.02553132867133
 |  | YPLTCOLCXX0IH | LVST | COLORMAN CTP PANORAMA  PLATE | -450 | -66190.29 |  |  | -450 | -66190.29 | 147.0895333333333
 |  |  |  | COLORMAN CTP PANORAMA  PLATE Total | -450 | -66190.29 |  |  | -450 | -66190.29 | 147.0895333333333
 |  | YPLTGMNCXX0AC | [NAME] | GEOMAN CTP PLATE | -21000 | -1563110.59 |  |  | -21000 | -1563110.59 | 74.43383761904761
 |  |  |  | GEOMAN CTP PLATE Total | -21000 | -1563110.59 |  |  | -21000 | -1563110.59 | 74.43383761904761
 |  | YPLTHARCXX0CE | LVST | HARRIS M 600 CTP PLATE | -900 | -178382.07 |  |  | -900 | -178382.07 | 198.2023
 |  |  |  | HARRIS M 600 CTP PLATE Total | -900 | -178382.07 |  |  | -900 | -178382.07 | 198.2023
 |  | YPLTHARCXX0DG | LVST | HARRIS M 300 CTP PLATE | -200 | -40892.2 |  |  | -200 | -40892.2 | 204.461
 |  |  |  | HARRIS M 300 CTP PLATE Total | -200 | -40892.2 |  |  | -200 | -40892.2 | 204.461
 |  | YPLTHNLCXX0BN | LVST | HILINE CTP PLATE | -6600 | -1033298.82 |  |  | -6600 | -1033298.82 | 156.5604272727273
 |  |  |  | HILINE CTP PLATE Total | -6600 | -1033298.82 |  |  | -6600 | -1033298.82 | 156.5604272727273
 |  | YTEKUNIX000XX | (blank) | [NAME] GUM UNIFIN | -60 | -5578.2 | 60 | 5578.2 | 0 | 0 | 92.97
 |  |  |  | [NAME] GUM UNIFIN Total | -60 | -5578.2 | 60 | 5578.2 | 0 | 0 | 92.97
 |  | YVSTHNLC028BN | (blank) | HILINE CTP PLATE | -1500 | -234478.64 | 1500 | 234478.64 | 0 | 0 | 156.3190933333333
 |  |  |  | HILINE CTP PLATE Total | -1500 | -234478.64 | 1500 | 234478.64 | 0 | 0 | 156.3190933333333
 | CTP-Mumbai Total |  |  |  | -125540 | -9742258.79 | 22060 | 1693493.98 | -103480 | -8048764.810000001 | 77.6028261111996
A130306042 | Newsline 45 - Kan | YBLKHNLXXX0EB | LPHNX | PRINTING BLANKET FOR HILINE MACHINE | -40 | -173283.75 |  |  | -40 | -173283.75 | 4332.09375
 |  |  |  | PRINTING BLANKET FOR HILINE MACHINE Total | -40 | -173283.75 |  |  | -40 | -173283.75 | 4332.09375
 |  | YCHEFNSSXX0BX | LTECH | FOUNTAIN SOLUTION FOR MANUGRAPH MACHINE | -2310 | -166412.8 |  |  | -2310 | -166412.8 | 72.04017316017315
 |  |  |  | FOUNTAIN SOLUTION FOR MANUGRAPH MACHINE Total | -2310 | -166412.8 |  |  | -2310 | -166412.8 | 72.04017316017315
 |  | YCHEMNRDXX0XX | LTECH | ROLLER DEGLAZER | -30 | -7029.05 |  |  | -30 | -7029.05 | 234.3016666666667
 |  |  |  | ROLLER DEGLAZER Total | -30 | -7029.05 |  |  | -30 | -7029.05 | 234.3016666666667
 |  | YCHEMNSSFC0XX | LTECH | FOUNT SYSTEM CLEANER FOR NON MAN MACHINE | -300 | -14581.53 |  |  | -300 | -14581.53 | 48.6051
 |  |  |  | FOUNT SYSTEM CLEANER FOR NON MAN MACHINE Total | -300 | -14581.53 |  |  | -300 | -14581.53 | 48.6051
 |  | YCHEMNSTGM0XX | LTECH | WASHOUT STORAGE GUM | -5 | -444.18 |  |  | -5 | -444.18 | 88.836
 |  |  |  | WASHOUT STORAGE GUM Total | -5 | -444.18 |  |  | -5 | -444.18 | 88.836
 |  | YCHEWSSSAM0BX | LTECH | BLANKET WASH FOR NON MAN MACHINE | -4830 | -417449.66 |  |  | -4830 | -417449.66 | 86.42850103519669
 |  |  |  | BLANKET WASH FOR NON MAN MACHINE Total | -4830 | -417449.66 |  |  | -4830 | -417449.66 | 86.42850103519669
 |  | YCHEWSSSND0AX | LTECH | BLANKET WASH FOR UV | -400 | -82254.84 |  |  | -400 | -82254.84 | 205.6371
 |  |  |  | BLANKET WASH FOR UV Total | -400 | -82254.84 |  |  | -400 | -82254.84 | 205.6371
 |  | YINKNLLC000BX | MIL | NEWSLINE CYAN 200 KG PACK | -3000 | -502512.21 |  |  | -3000 | -502512.21 | 167.50407
 |  | YINKNLLC000BX | DIC | NEWSLINE CYAN 200 KG PACK | -2100 | -502512.21 |  |  | -3000 | -502512.21 | 239.2915285714286
 |  | YINKNLLC000BX | SAK | NEWSLINE CYAN 200 KG PACK Total | -1799 | -502512.21 |  |  | -3000 | -502512.21 | 279.328632573652
 |  | YINKNLLCFL0EX | MIL | FLUORESCENT CYAN FOR NEWSLINE 5 KG PACK | -5 | -2967.35 |  |  | -5 | -2967.35 | 593.47
 |  |  |  | FLUORESCENT CYAN FOR NEWSLINE 5 KG PACK Total | -5 | -2967.35 |  |  | -5 | -2967.35 | 593.47
 |  | YINKNLLCUV0EX | AERT | ULTRAVIOLET CYAN INK NEWSLINE 5 KG PACK | -400 | -330960 |  |  | -400 | -330960 | 827.4
 |  |  |  | ULTRAVIOLET CYAN INK NEWSLINE 5 KG PACK Total | -400 | -330960 |  |  | -400 | -330960 | 827.4
 |  | YINKNLLK000BX | DIC | NEWSLINE BLACK 200 KG PACK | -10800 | -846049.6299999999 | 1800 | 141008.27 | -9000 | -705041.3599999999 | 78.3379287037037
 |  | YINKNLLK000BX | SAK | NEWSLINE BLACK 200 KG PACK Total | -9000 | -846049.6299999999 | 1800 | 141008.27 | -9000 | -705041.3599999999 | 94.00551444444443
 |  | YINKNLLK000BX | MIL | NEWSLINE BLACK 200 KG PACK Total | -8600 | -846049.6299999999 | 1800 | 141008.27 | -9000 | -705041.3599999999 | 98.37786395348836
 |  | YINKNLLKUV0EX | AERT | ULTRAVIOLET BLACK INK NEWSLINE 5 KG PACK | -575 | -475755 | 1 | 827.4 | -574 | -474927.6 | 827.4
 |  |  |  | ULTRAVIOLET BLACK INK NEWSLINE 5 KG PACK Total | -575 | -475755 | 1 | 827.4 | -574 | -474927.6 | 827.4
 |  | YINKNLLM000BX | MIL | NEWSLINE MAGENTA 200 KG PACK | -3600 | -603243.95 |  |  | -3600 | -603243.95 | 167.5677638888889
 |  | YINKNLLM000BX | SAK | NEWSLINE MAGENTA 200 KG PACK Total | -3000 | -603243.95 |  |  | -3600 | -603243.95 | 201.0813166666667
 |  | YINKNLLM000BX | DIC | NEWSLINE MAGENTA 200 KG PACK Total | -3400 | -603243.95 |  |  | -3600 | -603243.95 | 177.4246911764706
 |  | [NAME] | AERT | ULTRAVIOLET MAGENTA INK NEWSLINE 5 KG PK | -425 | -351645 | 25 | 20685 | -400 | -330960 | 827.4
 |  |  |  | ULTRAVIOLET MAGENTA INK NEWSLINE 5 KG PK Total | -425 | -351645 | 25 | 20685 | -400 | -330960 | 827.4
 |  | YINKNLLY000BX | MIL | NEWSLINE YELLOW 200 KG PACK | -4400 | -737281.27 |  |  | -4400 | -737281.27 | 167.563925
 |  | YINKNLLY000BX | DIC | NEWSLINE YELLOW 200 KG PACK Total | -3500 | -737281.27 |  |  | -3900 | -737281.27 | 210.6517914285714
 |  | YINKNLLY000BX | SAK | NEWSLINE YELLOW 200 KG PACK Total | -3000 | -737281.27 |  |  | -4400 | -737281.27 | 245.7604233333333
 |  | [NAME] | AERT | ULTRAVIOLET YELLOW INK NEWSLINE 5KG PACK | -600 | -496440 |  |  | -600 | -496440 | 827.4
 |  |  |  | ULTRAVIOLET YELLOW INK NEWSLINE 5KG PACK Total | -600 | -496440 |  |  | -600 | -496440 | 827.4
 |  | YPDNAPBTXX0XX | PRD_LOCAL | AP BUTTERFLY TAB 52MMX110MM 130-135 GSM | -10 | -5773.370000000001 |  |  | -10 | -5773.370000000001 | 577.3370000000001
 |  |  |  | AP BUTTERFLY TAB 52MMX110MM 130-135 GSM Total | -10 | -5773.370000000001 |  |  | -10 | -5773.370000000001 | 577.3370000000001
 |  | YPDNCMCCXX0XX | PRD_LOCAL | CLEANING MATERIAL CHEESE CLOTH | -1287.5 | -60834.39 |  |  | -1287.5 | -60834.39 | 47.25001165048543
 |  |  |  | CLEANING MATERIAL CHEESE CLOTH Total | -1287.5 | -60834.39 |  |  | -1287.5 | -60834.39 | 47.25001165048543
 |  | [NAME] | PRD_LOCAL | CLEANING MATERIAL WIPES 40 CMS X 55 CMS | -45000 | -116220.33 |  |  | -45000 | -116220.33 | 2.582674
 |  |  |  | CLEANING MATERIAL WIPES 40 CMS X 55 CMS Total | -45000 | -116220.33 |  |  | -45000 | -116220.33 | 2.582674
 |  | YPDNFLMTXX0DC | PRD_LOCAL | FILTER MAT FZ-250 397 X 897 MM | -30 | -2723.4 |  |  | -30 | -2723.4 | 90.77999999999999
 |  |  |  | FILTER MAT FZ-250 397 X 897 MM Total | -30 | -2723.4 |  |  | -30 | -2723.4 | 90.77999999999999
 |  | YPDNRDTBXX0XX | PRD_LOCAL | RED COLOUR TAB ON TINTD PAPER 130GSM THK | -5 | -2047.5 |  |  | -5 | -2047.5 | 409.5
 |  |  |  | RED COLOUR TAB ON TINTD PAPER 130GSM THK Total | -5 | -2047.5 |  |  | -5 | -2047.5 | 409.5
 |  | YPDNSPTPRP0XX | 3M | SPLICING REPULPABLE TAPES 12.5 MM | -60 | -12132.95 |  |  | -60 | -12132.95 | 202.2158333333333
 |  |  |  | SPLICING REPULPABLE TAPES 12.5 MM Total | -60 | -12132.95 |  |  | -60 | -12132.95 | 202.2158333333333
 |  | [NAME] | PKG_LOCAL | PLASTIC TWINE | -75 | -3622.5 |  |  | -75 | -3622.5 | 48.3
 |  |  |  | PLASTIC TWINE Total | -75 | -3622.5 |  |  | -75 | -3622.5 | 48.3
 |  | YTEKAMRW000BX | (blank) | [NAME] AMBERWASH  210 LITRES | -1050 | -90767.92 | 1050 | 90767.92 | 0 | 0 | 86.4456380952381
 |  |  |  | [NAME] AMBERWASH  210 LITRES Total | -1050 | -90767.92 | 1050 | 90767.92 | 0 | 0 | 86.4456380952381
 |  | [NAME] | (blank) | TECHNOVA FOUNT SYSTEM CLEANER | -100 | -4860.51 | 100 | 4860.51 | 0 | 0 | 48.6051
 |  |  |  | TECHNOVA FOUNT SYSTEM CLEANER Total | -100 | -4860.51 | 100 | 4860.51 | 0 | 0 | 48.6051
 |  | YTEKCRNX000BX | (blank) | TECHNOVA FOUNT CROWN JEWEL (210 L PACK) | -630 | -45385.31 | 630 | 45385.31 | 0 | 0 | 72.0401746031746
 |  |  |  | TECHNOVA FOUNT CROWN JEWEL (210 L PACK) Total | -630 | -45385.31 | 630 | 45385.31 | 0 | 0 | 72.0401746031746
 |  | YTEKNWDP000AX | (blank) | TECHNOVA NOVAWASH DP 25 LITRES | -100 | -20563.71 | 100 | 20563.71 | 0 | 0 | 205.6371
 |  |  |  | TECHNOVA NOVAWASH DP 25 LITRES Total | -100 | -20563.71 | 100 | 20563.71 | 0 | 0 | 205.6371