Spreadsheet: 165889d1341387294-add-cell-a-with-set-text-only-if-cell-a-falls-into-a-category-of-names-then-add-cell-b-test-workbook
Sheet: Dynamic Raw Feed

Dynamic Part Number | Product Name | Buy Price EX | Quantity | Manufacturer | Category | Weight | Model Number | Description | Description 2 | Particulars
1382925 | Lexm 1382925 Prebate Cart | 218.25 | 2 | Lexmark | LASER | 2.45 | 1382925 | Optra S 1250, 1255, 1620, 1625, 1650, 1855, 2420, 2450, 2455, 4059 | 17600 pages | Black
BDK11201 | Brother [NAME] Label | 15.1 | >5 | Brother | [NAME] | 0.024 | DK-11201 |  | 400 labels per roll | [NAME]
BDK11202 | Brother DK11202 White Label | 21.95 | >5 | Brother | [NAME] | 0.5 | DK-11202 |  | 300 labels per roll | [NAME]
BDK11204 | Brother DK11204 White Label | 13.15 | >5 | Brother | [NAME] | 0.012 | DK-11204 |  | 400 labels per roll | [NAME]
BDK11208 | Brother DK11208 White Label | 18.4 | >5 | Brother | [NAME] | 0.031 | DK-11208 |  | 400 labels per roll | [NAME]
BDK11209 | Brother DK11209 White Label | 23.15 | >5 | Brother | [NAME] | 0.033 | DK-11209 |  | 800 labels per roll | [NAME]
BDK22205 | Brother DK22205 White Roll | 21.75 | >5 | Brother | [NAME] | 0.41 | DK-22205 |  | 62mm x 30.48 metres | [NAME]
BFP4 | Brother FP4CL Fuser Unit | 366.9 | 5 | Brother | LASER | 2.5 | FP-4CL | HL2700CN, MFC9420CN | up to 60000 pages | [NAME]
BN04B | Brother TN04 Black Toner | 204.1 | >5 | Brother | LASER | 1.2 | TN-04B | HL2700CN, MFC9420CN | 10000 pages | Black
BN04C | Brother TN04 [NAME] | 204.1 | 1 | Brother | LASER | 1.2 | TN-04C | HL2700CN, MFC9420CN | 6600 pages | [NAME]
BN04Y | Brother TN04 [NAME] | 204.1 | >5 | Brother | LASER | 1.2 | TN-04Y | HL2700CN, MFC9420CN | 6600 pages | Yellow
BN150B | Brother [NAME] Toner Cart | 68.8 | >5 | Brother | LASER | 1.128 | TN-150BK | DCP9040CN, DCP9042CDN, HL4040CN, HL4050CDN, [NAME], MFC9450CDN, MFC9840CDW | 2500 pages | Black
BN150C | Brother [NAME] | 81.95 | >5 | Brother | LASER | 1.124 | TN-150C | DCP9040CN, DCP9042CDN, HL4040CN, HL4050CDN, [NAME], MFC9450CDN, MFC9840CDW | 1500 pages | [NAME]
[NAME] | Brother [NAME] Toner Cart | 81.95 | >5 | Brother | LASER | 1.124 | TN-150M | DCP9040CN, DCP9042CDN, HL4040CN, HL4050CDN, [NAME], MFC9450CDN, MFC9840CDW | 1500 pages | Magenta
BN150Y | Brother [NAME] Toner Cart | 81.95 | >5 | Brother | LASER | 1.124 | TN-150Y | DCP9040CN, DCP9042CDN, HL4040CN, HL4050CDN, [NAME], MFC9450CDN, MFC9840CDW | 1500 pages | Yellow
BN155B | Brother TN155 Blk Toner Cart | 107.05 | >5 | Brother | LASER | 1.2 | TN-155BK | DCP9040CN, DCP9042CDN, HL4040CN, HL4050CDN, [NAME], MFC9450CDN, MFC9840CDW | 5000 pages | Black
BN155C | Brother TN155 [NAME] Cart | 144 | >5 | Brother | LASER | 1.2 | TN-155C | DCP9040CN, DCP9042CDN, HL4040CN, HL4050CDN, [NAME], MFC9450CDN, MFC9840CDW | 4000 pages | [NAME]
BN155M | Brother TN155 [NAME] Cart | 144 | >5 | Brother | LASER | 1.2 | TN-155M | DCP9040CN, DCP9042CDN, HL4040CN, HL4050CDN, [NAME], MFC9450CDN, MFC9840CDW | 4000 pages | Magenta
BN155Y | Brother TN155 Yell Toner Cart | 144 | >5 | Brother | LASER | 1.2 | [NAME] | DCP9040CN, DCP9042CDN, HL4040CN, HL4050CDN, [NAME], MFC9450CDN, MFC9840CDW | 4000 pages | Yellow
BN1554PK | Brother TN155 [NAME] | 498.4 | >5 | Brother | LASER | 4.81 | TN-155CL4PK | DCP9040CN, DCP9042CDN, HL4040CN, HL4050CDN, [NAME], MFC9450CDN, MFC9840CDW | refer to singles | [NAME]
BN200 | Brother [NAME] Cartridge | 36.45 | >5 | Brother | LASER | 0.255 | TN-200 | HL720, HL730, HL760, HL770, Fax 2660, 2750, 3550, 3650, 3750, 8000p, 8200p, MFC4340, MFC4350, MFC4450, MFC4550, MFC4600, MFC4650, MFC6550MC, [NAME], MFC7300DX, MFC7550ML, MFC7650MC, MFC7750MC, MFC8000P, MFC9000, MFC9500 | 2200 pages | Black
BN2025 | Brother TN2025 Toner Cartridge | 59.15 | >5 | Brother | LASER | 0.85 | TN-2025 | HL2040, HL2070N, MFC7220, MFC7420, MFC7820N, FAX 2820, FAX 2890, FAX 2920 | 2500 pages | Black
BN2025T | Brother TN2025 Twin Pack | 110.65 | >5 | Brother | LASER | 2.02 | TN-20252PK | HL2040, HL2070N, MFC7220, MFC7420, MFC7820N, FAX 2820, FAX 2890, FAX 2920 | 2500 pages each | Black
BN2030 | Brother TN2030 Toner Cartridge | 35.75 | >5 | Brother | LASER | 0.78 | TN-2030 | DCP7055, HL2130, HL2132 | 1000 pages | Black
BN2130 | Brother TN2130 [NAME] | 45.85 | >5 | Brother | LASER | 1 | TN-2130 | DCP7040, HL2140, HL2142, HL2150N, HL2170W, MFC7340, [NAME], MFC7840W | 1500 pages | Black
BN2150 | Brother TN2150 Toner Cartridge | 62.15 | >5 | Brother | LASER | 1 | TN-2150 | DCP7040,HL2140, HL2142, HL2150N, HL2170W, MFC7340, [NAME], MFC7840W | 2600 pages | Black
BN21503PK | Brother TN2150 Toner 3 Pack | 177.55 | >5 | Brother | LASER | 3.5 | TN-21503PK | DCP7040,HL2140, HL2142, HL2150N, HL2170W, MFC7340, [NAME], MFC7840W | 2600 pages each | Black
BN2230 | Brother TN2230 [NAME] | 40.6 | >5 | Brother | LASER | 0.765 | TN-2230 | DCP7060D, DCP7065DN, HL2240D, HL2242D, [NAME], HL2270DW, MFC7360N, MFC7362, MFC7460DN, MFC7860DW | 1200 pages | Black
BN2250 | Brother TN2250 Toner Cartridge | 70.75 | >5 | Brother | LASER | 0.78 | TN-2250 | DCP7060D, DCP7065DN, HL2240D, HL2242D, [NAME], HL2270DW, MFC7360N, MFC7362, MFC7460DN, MFC7860DW | 2600 pages | Black
BN240B | Brother [NAME] Toner Cart | 64.2 | >5 | Brother | LASER | 0.78 | TN-240BK | DCP9010CN, HL3070CW, HL3040CN, HL3045CN, MFC9120CN, [NAME],  MFC9320CW, MFC9325CW | 2200 pages | Black
BN240C | Brother [NAME] Cart | 60.55 | >5 | Brother | LASER | 0.78 | TN-240C | DCP9010CN, HL3070CW, HL3040CN, HL3045CN, MFC9120CN, [NAME],  MFC9320CW, MFC9325CW | 1400 pages | [NAME]
BN240M | Brother [NAME] Toner Cart | 60.55 | >5 | Brother | LASER | 0.78 | TN-240M | DCP9010CN, HL3070CW, HL3040CN, HL3045CN, MFC9120CN, [NAME],  MFC9320CW, MFC9325CW | 1400 pages | Magenta
BN240Y | Brother [NAME] Cart | 60.55 | >5 | Brother | LASER | 0.78 | [NAME] | DCP9010CN, HL3070CW, HL3040CN, HL3045CN, MFC9120CN, [NAME],  MFC9320CW, MFC9325CW | 1400 pages | Yellow
BN2404PK | Brother TN240 Colour [NAME] | 230.05 | >5 | Brother | LASER | 3.31 | TN-240CL4PK | DCP9010CN, HL3070CW, HL3040CN, HL3045CN, MFC9120CN, [NAME],  MFC9320CW, MFC9325CW | refer to singles | [NAME]
BN3030 | Brother TN3030 Toner Cartridge | 70.15 | >5 | Brother | LASER | 0.99 | TN-3030 | HL5140, HL5150D, HL5170DN, [NAME], MFC8440, MFC8840 | 3500 pages | Black
BN3060 | Brother TN3060 [NAME] | 96.35 | >5 | Brother | LASER | 1 | TN-3060 | HL5140, HL5150D, HL5170DN, [NAME], MFC8440, MFC8840 | 6700 pages | Black
BN3145 | Brother TN3145 [NAME] | 72.55 | >5 | Brother | LASER | 1 | TN-3145 | HL5240, HL5250DN, HL5270DN, MFC8460N, MFC8860DN | 3500 pages | Black
BN3185 | Brother TN3185 Toner Cartridge | 96.7 | >5 | Brother | LASER | 1.1 | TN-3185 | HL5240, HL5250DN, HL5270DN, MFC8460N, MFC8860DN | 7000 pages | Black
BN3250 | Brother TN3250 Toner Cartridge | 75.55 | >5 | Brother | LASER | 1.07 | TN-3250 | HL5340D, HL5350DN, HL5370DW, HL5380DN, MFC8880DN, MFC8890DW, MFC8370DN | 3000 pages | Black
BN3290 | Brother TN3290 [NAME] | 128.65 | >5 | Brother | LASER | 1.172 | TN-3290 | HL5340D, HL5350DN, HL5370DW, HL5380DN, MFC8880DN, MFC8890DW, MFC8370DN | 8000 pages | Black
BN340B | Brother [NAME] Toner Cart | 66.2 | >5 | Brother | LASER | 0.8 | [NAME] | DCP9055CDN, HL4150CDN, HL4570CDW, MFC9460CDN, MFC9970CDW | 2500 pages | Black
BN340C | Brother [NAME] | 66.2 | >5 | Brother | LASER | 0.8 | TN-340C | DCP9055CDN, HL4150CDN, HL4570CDW, MFC9460CDN, MFC9970CDW | 1500 pages | [NAME]
[NAME] | Brother [NAME] Toner Cart | 66.2 | >5 | Brother | LASER | 0.8 | TN-340M | DCP9055CDN, HL4150CDN, HL4570CDW, MFC9460CDN, MFC9970CDW | 1500 pages | Magenta
BN340Y | Brother [NAME] Toner Cart | 66.2 | >5 | Brother | LASER | 0.8 | [NAME] | DCP9055CDN, HL4150CDN, HL4570CDW, MFC9460CDN, MFC9970CDW | 1500 pages | Yellow
[NAME] | Brother [NAME] | 114.2 | >5 | Brother | LASER | 0.875 | TN-348BK | DCP9055CDN, HL4150CDN, HL4570CDW, MFC9460CDN, MFC9970CDW | 6000 pages | Black
BN348C | Brother [NAME] | 189.45 | >5 | Brother | LASER | 0.795 | TN-348C | DCP9055CDN, HL4150CDN, HL4570CDW, MFC9460CDN, MFC9970CDW | 6000 pages | [NAME]
BN348M | Brother [NAME] Toner Cart | 189.45 | >5 | Brother | LASER | 0.795 | TN-348M | DCP9055CDN, HL4150CDN, HL4570CDW, MFC9460CDN, MFC9970CDW | 6000 pages | Magenta
BN348Y | Brother [NAME] | 189.45 | >5 | Brother | LASER | 0.795 | TN-348Y | DCP9055CDN, HL4150CDN, HL4570CDW, MFC9460CDN, MFC9970CDW | 6000 pages | Yellow
BN4100 | Brother TN4100 [NAME] | 113.8 | >5 | Brother | LASER | 1.4 | TN-4100 | HL6050D, HL6050DN | 7500 pages | Black
BN5500 | Brother [NAME] | 114 | >5 | Brother | LASER | 1.442 | TN-5500 | HL7050 | 12000 pages | Black
BN6300 | Brother TN6300 Toner Cartridge | 65.15 | >5 | Brother | LASER | 0.972 | TN-6300 | HL1230, HL1240, HL1250, HL1270N, HL1430, HL1440, HL1450, HL1470N,Fax 8360P, P2500, 4750, 5750, MFC8600, MFC9600, MFC9660, MFC9880 | 3000 pages | Black
BN6600 | Brother TN6600 [NAME] | 91.4 | >5 | Brother | LASER | 1.014 | TN-6600 | HL1230, HL1240, HL1250, HL1270N, HL1430, HL1440, HL1450, HL1470N,Fax 8360P, P2500, 4750, 5750, MFC8600, MFC9600, MFC9660, MFC9880 | 6000 pages | Black
BN7300 | Brother TN7300 Toner Cartridge | 70.75 | >5 | Brother | LASER | 0.962 | TN-7300 | HL1650, HL1670, HL1850, HL1870, HL5040, HL5050, HL5070,MFC8420, MFC8820D, DCP8020, DCP8025, DCP8820 | 3300 pages | Black
BN7600 | Brother TN7600 [NAME] | 95.3 | >5 | Brother | LASER | 1.022 | TN-7600 | HL1650, HL1670, HL1850, HL1870, HL5040, HL5050, HL5070,MFC8420, MFC8820D, DCP8020, DCP8025, DCP8820 | 6500 pages | Black
BN8000 | Brother TN8000 [NAME] | 36.45 | >5 | Brother | LASER | 0.3 | TN-8000 | FAX2850, FAX8070P, [NAME], MFC9180 | 2200 pages | Black
[NAME] | Brother OP4CL OPC Belt Cart | 360.3 | >5 | Brother | LASER | 2 | OP-4CL | HL2700CN, MFC9420CN | 60000 pages | [NAME]
BR150 | Brother DR150CL Drum Unit | 223.6 | >5 | Brother | LASER | 3.02 | DR-150CL | HL4040CN, HL4050CDN, DCP9040CN, DCP9042, [NAME], MFC9450CDN, MFC9840CDW | 17000 pages | Drum
BR2025 | Brother DR2025 Drum Unit | 121.35 | >5 | Brother | LASER | 0.75 | DR-2025 | HL2040, HL2070, MFC7220, MFC7420, MFC7820N, FAX2820, FAX 2890, FAX 2920 | 12000 pages | Drum
BR2125 | Brother DR2125 Drum Unit | 89.75 | >5 | Brother | LASER | 0.7 | DR-2125 | HL2140, HL2142, HL2150N, HL2170W, MFC7340, [NAME], MFC7840W, DCP7040 | up to 12000 pages | Drum
BR2225 | Brother DR2225 Drum Unit | 77.6 | >5 | Brother | LASER | 0.78 | DR-2225 | DCP7055, DCP7060D, DCP7065DN, HL2130, HL2132, HL2240D, HL2242D, [NAME], HL2270DW, MFC7360N, MFC7362, MFC7460DN, MFC7860DW | up to 12000 pages | Drum
BR240 | Brother DR240CL Drum Unit | 160.4 | >5 | Brother | LASER | 2.214 | DR-240CL | DCP9010CN, HL3070CW, HL3040CN, HL3045CN, MFC9120CN, [NAME],  MFC9320CW, MFC9325CW | 15000 pages | Drum
BR3000 | Brother DR3000 Drum Unit | 170.6 | >5 | Brother | LASER | 0.86 | DR-3000 | HL5140, HL5150D, HL5170DN, [NAME], MFC8440, MFC8840 | 20000 pages | Drum
BR3115 | Brother DR3115 Drum Unit | 193.85 | >5 | Brother | LASER | 0.855 | [NAME] | HL5240, HL5250DN, HL5270DN, MFC8460N, MFC8860DN | 25000 pages | Drum
BR3215 | Brother DR3215 Drum Unit | 171.5 | >5 | Brother | LASER | 0.85 | DR-3215 | HL5340D, HL5350DN, HL5370DW, HL5380DN, MFC8880DN, MFC8890DW, MFC8370DN | 25000 pages | Drum
[NAME] | Brother DR340CL Drum Unit | 164.75 | >5 | Brother | LASER | 2.61 | BR-340CL | DCP9055CDN, HL4150CDN, HL4570CDW, MFC9460CDN, MFC9970CDW | 25000 pages | Drum
BR4000 | Brother DR4000 Drum Unit | 161.35 | >5 | Brother | LASER | 1.4 | DR-4000 | [NAME] | 30000 pages | Drum
BR5500 | Brother DR5500 Drum Unit | 120.4 | >5 | Brother | LASER | 1.146 | DR-5500 | HL7050 | 40000 pages | Drum
BR6000 | Brother DR6000 Drum Unit | 176.2 | >5 | Brother | LASER | 0.084 | DR-6000 | HL1230, HL1240, HL1250, HL1270N, HL1430, HL1440, HL1450, HL1470N,Fax 8360P, P2500, 4750, 5750, MFC8600, MFC9600, MFC9660, MFC9880 | 20000 pages | Drum
BR7000 | Brother DR7000 Drum Unit | 177.8 | >5 | Brother | LASER | 0.835 | DR-7000 | HL1650, HL1670, HL1850, HL1870, HL5040, HL5050, HL5070,MFC8420, MFC8820D, DCP8020, DCP8025, DCP8820 | 20000 pages | Drum
BR8000 | Brother DR8000 Drum Unit | 210.6 | >5 | Brother | LASER | 1.27 | DR-8000 | FAX2850, FAX8070P, [NAME], MFC9180 | 8000 pages | Drum
BTZ111 | Brother [NAME] | 10.1 | >5 | Brother | [NAME] | 0.046 | TZ-111 |  | 8 metres | Labelling Tape
BTZ121 | Brother [NAME] Tape | 11.6 | >5 | Brother | [NAME] | 0.11 | TZ-121 | PT300, 320, 330, 340, 540, [NAME], 1200, 1750 | 8 metres | Labelling Tape
BTZ131 | Brother [NAME] | 12.75 | >5 | Brother | [NAME] | 0.052 | TZ-131 | PT540, [NAME] | 8 metres | Labelling Tape
BTZ135 | Brother TZ135 Labelling Tape | 12.15 | >5 | Brother | [NAME] | 0.05 | TZ-135 |  | 8 metres | Labelling Tape
BTZ141 | Brother [NAME] | 15.85 | >5 | Brother | [NAME] | 0.11 | TZ-141 | PT300, 320, 330, 340, 540, 580c,1200,1750 | 8 metres | Labelling Tape
BTZ151 | Brother [NAME] | 18.75 | >5 | Brother | [NAME] | 0.11 | TZ-151 | PT530, 540, [NAME], 2500pc | 8 metres | Labelling Tape
BTZ211 | Brother [NAME] | 11.6 | >5 | Brother | [NAME] | 0.11 | TZ-211 | PT300, 320, 330, 340, 540, [NAME], 1200, 1750 | 8 metres | Labelling Tape
[NAME] | Brother [NAME] | 12.75 | >5 | Brother | [NAME] | 0.052 | TZ-221 | PT300, 320, 540, [NAME] | 8 metres | Labelling Tape
BTZ222 | Brother [NAME] Tape | 13.15 | >5 | Brother | [NAME] | 0.05 | TZ-222 |  | 8 metres | Labelling Tape
BTZ223 | Brother [NAME] | 13.15 | >5 | Brother | [NAME] | 0.05 | TZ-223 |  | 8 metres | Labelling Tape
BTZ231 | Brother [NAME] | 11.85 | >5 | Brother | [NAME] | 0.11 | TZ-231 | PT540, [NAME] | 8 metres | Labelling Tape
BTZ232 | Brother [NAME] | 14.15 | >5 | Brother | [NAME] | 0.11 | TZ-232 | PT300, 320, 330, 340, 540, [NAME], 1200, 1750 | 8 metres | Labelling Tape
BTZ233 | Brother [NAME] | 13.8 | >5 | Brother | [NAME] | 0.052 | TZ-233 |  | 8 metres | Labelling Tape
BTZ241 | Brother [NAME] | 16.9 | >5 | Brother | [NAME] | 0.07 | TZ-241 | PT540, [NAME] | 8 metres | Labelling Tape
BTZ242 | Brother [NAME] | 17.25 | >5 | Brother | [NAME] | 0.07 | TZ-242 |  | 8 metres | Labelling Tape
BTZ243 | Brother [NAME] Tape | 17.25 | >5 | Brother | [NAME] | 0.07 | TZ-243 |  | 8 metres | Labelling Tape
BTZ251 | Brother [NAME] | 19.75 | >5 | Brother | [NAME] | 0.11 | TZ-251 | PT530, 540, [NAME], 2500pc | 8 metres | Labelling Tape
BTZ253 | Brother TZ253 Labelling Tape | 20.3 | >5 | Brother | [NAME] | 0.084 | TZ-253 |  | 8 metres | Labelling Tape
BTZ261 | Brother [NAME] | 30.3 | >5 | Brother | [NAME] | 0.145 | TZ-261 | PT530 | 8 metres | Labelling Tape
BTZ325 | Brother [NAME] | 15.55 | >5 | Brother | [NAME] | 0.05 | TZ-325 |  | 8 metres | Labelling Tape
BTZ334 | Brother [NAME] Tape | 16.9 | >5 | Brother | [NAME] | 0.052 | TZ-334 |  | 8 metres | Labelling Tape
BTZ335 | Brother [NAME] | 16.9 | >5 | Brother | [NAME] | 0.052 | TZ-335 | PT300, 320, 330, 340, 540, [NAME], 1750 | 8 metres | Labelling Tape
BTZ345 | Brother TZ345 Labelling Tape | 19.9 | >5 | Brother | [NAME] | 0.07 | TZ-345 |  | 8 metres | Labelling Tape
BTZ355 | Brother [NAME] Tape | 22.8 | >5 | Brother | [NAME] | 0.084 | TZ-355 |  | 8 metres | Labelling Tape
BTZ431 | Brother [NAME] | 14.15 | >5 | Brother | [NAME] | 0.052 | TZ-431 |  | 8 metres | Labelling Tape
BTZ435 | Brother [NAME] | 17.25 | >5 | Brother | [NAME] | 0.052 | TZ-435 |  | 8 metres | Labelling Tape
[NAME] | Brother [NAME] | 13.8 | >5 | Brother | [NAME] | 0.052 | TZ-531 |  | 8 metres | Labelling Tape
BTZ535 | Brother [NAME] | 16.9 | >5 | Brother | [NAME] | 0.052 | TZ-535 |  | 8 metres | Labelling Tape
BTZ555 | Brother [NAME] Tape | 22.8 | >5 | Brother | [NAME] | 0.084 | TZ-555 |  | 8 metres | Labelling Tape