Spreadsheet: 762682d1641732438-vlookup-help-to-get-a-value-when-3-item-match-3-on-another-sheet-example
Sheet: Labels.

QRef: |  | [NAME] |  |  |  |  | upto 6,000 | 7,000 to 10,000 | [NAME]
 | [NAME] | Size | Type | Material | Adhesive | Quanity on Roll | Price per 1,000 | Price per 1,000 | Recommended
 |  | Other Sizes Available |  |  |  |  |  |  | Re-SELL
 |  |  | BLANKS |  |  |  |  |  | ADD
10973 | JB 3778 | 108 x 150mm | Blanks for [NAME] C7500C Inkjet | White  Gloss Digi PolyProp | Ultra Peel | 1000 |  |  |  |  |  | Blanks for [NAME] C7500C Inkjet | 108 x 150mm | White  Gloss Digi PolyProp
10974 |  | 102 x 98mm | Blanks for [NAME] C7500C Inkjet | White  Gloss Digi PolyProp | Ultra Peel | 1000 |  |  |  |  |  | Blanks  for Thermal printer using Thermal Ribbon | 102 x 98mm | White Gloss Digi Paper
10975 | JB 4040 | 85 x 35mm | Blanks for [NAME] C7500C Inkjet | White  Gloss Digi PolyProp | Ultra Peel | 1000 |  |  |  |  |  | Blank  for Direct Thermal print      ( No ribbon req) | 85 x 35mm | White Gloss Digi Paper
10976 |  | 108 x 150mm | Blanks for [NAME] C7500C Inkjet | White Gloss Digi Paper | Ultra Peel | 1,000 |  |  |  |  |  | Blank Coloured Dots | 102 x 99mm | Gloss White - Print Receptive - PolyProp
10977 |  | 102 x 99mm | Blanks for [NAME] C7500C Inkjet | White Gloss Digi Paper | Ultra Peel | 1,000 |  |  |  |  |  | Blank  Coloured Dots | 85 x  35mm | Direct thermal [NAME] Paper
10979 |  | 85 x  35mm | Blanks for [NAME] C7500C Inkjet | White Gloss Digi Paper | Ulra Peel | 1,000 |  |  |  |  |  | Blank Coloured Paper | 108 x150mm | Direct thermal [NAME] Paper
 |  | 108 x150mm | Blanks  for Thermal printer using Thermal Ribbon | Gloss White - Print Receptive - PolyProp | Peel | 1000 |  |  |  |  |  | Printed/Black - Template | 80 x 30mm | Direct thermal Various Coloured Paper
 |  | 102 x 98mm | Blanks  for Thermal printer using Thermal Ribbon | Gloss White - Print Receptive - PolyProp | Peel | 1000 |  |  |  |  |  | Printed/Black (Attention) | 95 x 40mm | Radiant Standard Colours - Paper
 |  | 85 x 35mm | Blanks  for Thermal printer using Thermal Ribbon | Gloss White - Print Receptive - PolyProp | Peel | 1000 |  |  |  |  |  | Printed/Black&Green (Q.C.) | 100 x 35mm | Standard Coloured Paper
 |  | 108 x 150mm | Blank  for Direct Thermal print      ( No ribbon req) | Direct thermal [NAME] Paper | Peel | 1000 |  |  |  |  |  | Printed/Black (QA Inspected) | 25mm [NAME] | Coloured paper (Pink)
 |  | 102 x 98mm | Blank  for Direct Thermal print      ( No ribbon req) | Direct thermal [NAME] Paper | Peel | 1000 |  |  |  |  |  | Printed/Two colour (Certified Product) | 12mm [NAME] | Gloss clear PP (polyprop)
 |  | 80 x 30mm | Blank  for Direct Thermal print      ( No ribbon req) | Direct thermal [NAME] Paper | Peel | 1000 |  |  |  |  |  | Printed Black (Stillage Barcode Numbered) | 50 x 18mm | Radiant Orange paper
10869 | JB 062 | 95 x 40mm | Blank  for Direct Thermal print      ( No ribbon req) | Direct thermal [NAME] Paper | Peel | 2000 |  |  |  |  |  |  | 20mm dia | Various coloured - papers
10869 | JB 062 | 95 x 40mm | Blank  for Direct Thermal print      ( No ribbon req) | Direct thermal [NAME] Paper | Peel | 2000 |  |  |  |  |  |  | 50 x 100mm | Radiant Green litho paper
10881 | JB 1318 | 100 x 35mm | Blank/Various std Colours- for Direct Thermal Print | Direct thermal Various Coloured Paper | Peel | 2000 |  |  |  |  |  |  | 40 x 100mm | Radiant Chrome litho paper
10870 | JB 529 | 25mm [NAME] | Blank Coloured Dots | Radiant Standard Colours - Paper | Peel / Perm | 1000 |  |  |  |  |  |  | 75 x 25mm | White semi-gloss paper
10872 | JB 437 | 12mm [NAME] | Blank  Coloured Dots | Standard Coloured Paper | Perm | 1000 |  |  |  |  |  |  | 51 x 76mm | Ultra Destruct PVC
10989 | JB  140 | 25mm [NAME] | Blank Coloured Paper | Standard Coloured Paper | Perm | 1000 |  |  |  |  |  |  | 102 x 150mm | [NAME] white Vinyl - Overlaminated
10990 | JB 497 | 50 x 18mm | Printed/Black (Leads etc) | Coloured paper (Pink) | Perm | 1000 |  |  |  |  |  |  | 185 x 20mm | [NAME] white Vinyl - Ultra Destruct
10991 | JB 559 | 20mm dia | Printed/White - Kite [NAME] | Gloss clear PP (polyprop) | Perm | 1000 |  |  |  |  |  |  | 210 x 147mm
10992 | JB 607 | 50 x 100mm | Printed/Black - Coated Glass | Radiant Orange paper | Peel | 1000 |  |  |  |  |  |  | 23 x 155mm
10993 | JB 727 | 50 x 100mm | Printed/Black - Coated Glass | Various coloured - papers | Peel | 1000
10994A | JB 1046 | 40 x 100mm | Printed/Black  - Despatch | Radiant Green litho paper | Peel | 1000
10994B | JB 1047 | 40 x 100mm | Printed/Black - Template | Radiant Chrome litho paper | Peel | 1000
10995 | JB 3344 | 75 x 25mm | Printed/Black (Attention) | Radiant Orange paper | Peel | 1000
10996 | JB 1166 | 51 x 76mm | Printed/Red (This Way Up) | White semi-gloss paper | Peel | 1000
10997 | JB 1488 | 20mm dia | Printed/Black&Green (Q.C.) | White semi-gloss paper | Peel | 1000
POA | JB 498 | 102 x 150mm | Printed/Black (QA Inspected) | White semi-gloss paper | Perm | 1000
POA | JB 2570 | 185 x 20mm | Printed/Two colour (Certified Product) | Ultra Destruct PVC | Perm | 1000
10999 | JB 1162 | 210 x 147mm | Printed/Red (Stillage) | [NAME] white Vinyl - Overlaminated | Hi [NAME] | 250
11000 | JB 4112 | 23 x 155mm | Printed Black (Stillage Barcode Numbered) | [NAME] white Vinyl - Ultra Destruct | Hi [NAME] | 250
 |  |  | ANCILLARY |  |  |  | Discounts on | Higher Quantities
 |  | 914mm x 15mts | [NAME] Clear Film | 175mic Super Clear Polyester | High Tack | Full roll |  | £98.00 per roll | Sell £155.80
 |  |  |  |  |  |  |  | Smaller rolls selling
 |  |  |  |  |  |  |  | 500mm x 3mts
 |  |  |  |  |  |  |  | £21.40 =
 |  |  |  |  |  |  |  | Roll 914mm £195.60
 |  |  |  |  |  |  |  | larger roll  saving | £39.80