Spreadsheet: 269871d1381312092-how-to-get-results-depending-of-a-text-in-other-column-960075
Sheet: Sheet1

Part Type | PISL Part Number | Unit Cost £ | Description | Pic | Quantity | Unit | Total | Supplier | Part no. | [NAME]' | Manu' Part No. | Av. Lead Time | Used On | Previous Order No. | Supply Code | Type Code
 | Z-B-SB-OR4.6x2.4 | 11.66 | O'Ring 4.6ID x 2.4CS, Nitrile, hardness 70 shore, black |  |  | pack |  | [NAME] |  |  |  | 1-2 days | C-Clamp | 32583/RFW
 |  | 0.74 | stainless steel, torsion spring |  |  | item |  | [NAME] | LTL 032F 01 S |  |  | 1-2 days | C-Clamp | 32614/RFW
 |  | 0.74 | stainless steel, torsion spring |  |  | item |  | [NAME] | LTR 032F 01 S |  |  | 1-2 days | C-Clamp | 32614/RFW
 |  | 2.8 | [NAME], Drawing No. P15864-0109, st steel 303 |  |  | item |  | Axis PEC | P15864-0109 |  |  |  | C-Clamp | 32286A/DPQ
 |  | 2.8 | [NAME] screw, Drawing No. P15864-0112, st steel 303 |  |  | item |  | Axis PEC | P15864-0112 |  |  |  | C-Clamp | 32286A/DPQ
 |  | 24.6 | SHORT CLAMP ARM, Drawing No. P15864-0123, Alum 6082 (HE 30) |  |  | item |  | [NAME]. | P15864-0123 |  |  |  | C-Clamp | 32459/DPQ
 |  | 26.4 | LONG CLAMP ARM, Drawing No. P15864-0124, Alum 6082 (HE 30) |  |  | item |  | [NAME]. | P15864-0124 |  |  |  | C-Clamp | 32459/DPQ
 |  | 6.65 | END CAP, Drawing No. P15864-0126, st steel 303 |  |  | item |  | [NAME]. | P15864-0126 |  |  |  | C-Clamp | 32459/DPQ
 |  | 1.65 | [NAME], Drawing No. P15864-0125, st steel 303 |  |  | item |  | [NAME]. | P15864-0125 |  |  |  | C-Clamp | 32459/DPQ
 |  | 2.15 | Switch,p/btn,IP67,green button,off-mom |  |  | item |  | RS | 702-3596 | KNITTER-SWITCH | DPW1CGG | 1-2 days | Tracer
 |  | 2.15 | Switch,p/btn,IP67,red button,off-mom |  |  | item |  | RS | 702-3592 | KNITTER-SWITCH | DPW1CGR | 1-2 days | Tracer
 |  | 10.26 | 8.1[NAME] IP67 red LED panelindicator,5/6Vdc |  |  | item |  | RS | 234-9420 | Marl | 677-501-20 | 1-2 days | Tracer
 |  | 10.59 | 8.1[NAME] IP67 green LED panelindicator,5/6Vdc |  |  | item |  | RS | 234-9458 | Marl | 677-532-20 | 1-2 days | Tracer
 |  | 2.13 | Female screw lock M3 - Delta D (pack of 10) |  |  | pack |  | RS | 673-4945 | FCI | 863001018TLF | 1-2 days | Tracer
 |  | 4.19 | 5mm dia x 3mm thick N42 Neodymium Magnet - 0.7kg Pull (Pk Qty 25) |  |  | pack |  | FIRST4MAGNETS | F640 |  |  | 1-2 days | Tracer | 32547/RFW
 |  | 5.22 | 25mm dia x 8mm thick x 5mm c/sink N42 Neodymium Pot Magnet |  |  | item |  | FIRST4MAGNETS | F4MA25 |  |  | 1-2 days | Tracer | 32547/RFW
 |  | 29.5 | 7kg Suction Mount With 5/8" [NAME] |  |  | item |  | GGR [NAME] | AHM15 |  |  | 1-2 days | Tracer | 32550/RFW
 |  | 27.25 | ARDUINO - A000067 - ATMEGA2560, ARDUINO MEGA2560 REV3, BOARD |  |  | item |  | Farnell | 221-2779 | Arduino | A000067 | 1-2 days | Tracer | 32084
 | Z-B-SB-3M-STR-ENC | 480 | 3m Linear string encoder, [NAME] |  |  | item |  | Scan Buddy |  |  |  |  | Tracer | 32068/NH
 |  | 24.6 | Hama, clamp and Table Top Pod, opening 4cm |  |  | item |  | cyber port | 7192-142 | Hama | 00004003 | 3-10+ days | Tracer | 32563/RFW
 |  | 14.3 | TRACER HOOK MOUNT |  |  | item |  | [NAME]. | P15864-0207 |  |  |  | Tracer | 32360/DPQ
 |  | 23.05 | MAGNET MOUNTING BLOCK |  |  | item |  | [NAME]. | P15864-0205 |  |  |  | Tracer | 32360/DPQ
 |  | 12.75 | THREAD MOUNTING BLOCK |  |  | item |  | [NAME]. | P15864-0206 |  |  |  | Tracer | 32360/DPQ
 |  | 0.8 | [NAME] Head [NAME] |  |  | item |  | [NAME] | GUTB3-4-10 |  |  | 2-5 days | Tracer | 32546/RFW
 |  | 23.3 | OUTER ARMS |  |  | item |  | Axis PEC | A1-Q12400-01 ITEM 1 |  |  |  | Caliper | 31327/DPQ
 |  | 23.3 | INNER ARMS |  |  | item |  | Axis PEC | A1-Q12400-01 ITEM 2 |  |  |  | Caliper | 31327/DPQ
 |  | 36 | ENCODER MOUNT - BLACK |  |  | item |  | Axis PEC | A1-Q12400-01 ITEM 3 |  |  |  | Caliper | 31327/DPQ
 |  | 15 | ENCODER WHEEL - BLACK |  |  | item |  | Axis PEC | A1-Q12400-01 ITEM 6 |  |  |  | Caliper | 30740/DPQ
 |  | 5.59 | CENTER SPACER |  |  | item |  | Axis PEC | A1-Q12400-01 ITEM 7 |  |  |  | Caliper | 31327/DPQ
 |  | 5.79 | OUTER SPACER |  |  | item |  | Axis PEC | A1-Q12400-01 ITEM 8 |  |  |  | Caliper | 31327/DPQ
 |  | 17.55 | LOCKING HINGE PIN |  |  | item |  | Axis PEC | A1-Q12400-01 ITEM 9 |  |  |  | Caliper | 31327/DPQ
 |  | 2.22 | Recoil, Wire Thread Insert, [NAME] (pack of 10) |  |  | pack |  | Stella Seven | 25052 | Recoil | 05052 | 2-3 days | Caliper | 32566/RFW
 |  | 9.68 | Knurled thumb screw [NAME] dia x M5 (pack of 20) |  |  | pack |  | RS | 771-673 | RS |  | next day | Caliper
 |  | 6.4 | Knurled thumb screw knob,13[NAME] x M4 (pack of 20) |  |  | pack |  | RS | 771-667 | RS |  | next day | Caliper
 |  | 13.44 | Nylon female scallop handwheel knob,M5 (pack of 10) |  |  | pack |  | RS | 161-076 | RS |  | next day | Caliper
 |  | 18.46 |  |  |  | item |  | Axis PEC | A4-P9425-02
 |  | 22.5 |  |  |  | item |  | Axis PEC | A4-P9425-10
 |  | 22.5 |  |  |  | item |  | Axis PEC | A4-P9425-03
 |  | 17 |  |  |  | item |  | Axis PEC | A4-P9425-05
 |  | 18 |  |  |  | item |  | Axis PEC | A4-P9425-06
 |  | 5.2 |  |  |  | item |  | Axis PEC | A4-P9425-07
 |  | 14.3 |  |  |  | item |  | Axis PEC | A4-P9425-14
 |  |  |  |  |  |  |  | Axis PEC