Spreadsheet: 850930d1701239672-index-match-multiple-criteria-returns-n-a-have-checked-with-values-all-are-exactly-same-po-number
Sheet: Sheet3

Nomenclature | CATEGORY | SIZE | TYPE | RETAIL/PROJECT | UOM
X1 | MULTISTRAND FR (90MTRS) | 0.75 mm² | MST | RETAIL | COILS
X2 | MULTISTRAND FR (90MTRS) | 1.0 mm² | MST | RETAIL | COILS
X3 | MULTISTRAND FR (90MTRS) | 1.5 mm² | MST | RETAIL | COILS
X4 | MULTISTRAND FR (90MTRS) | 2.5 mm² | MST | RETAIL | COILS
X5 | MULTISTRAND FR (90MTRS) | 4.0 mm² | MST | RETAIL | COILS
X6 | MULTISTRAND FR (90MTRS) | 6.0 mm² | MST | RETAIL | COILS
X7 | MULTISTRAND FR (90MTRS) | 10.0 mm² | MST | RETAIL | COILS
X8 | MULTISTRAND FR (90MTRS) | 16.0 mm² | MST | RETAIL | COILS
X9 | MULTISTRAND FRLS (90MTRS) | 0.75 mm² | MST | RETAIL | COILS
X10 | MULTISTRAND FRLS (90MTRS) | 1.0 mm² | MST | RETAIL | COILS
X11 | MULTISTRAND FRLS (90MTRS) | 1.5 mm² | MST | RETAIL | COILS
X12 | MULTISTRAND FRLS (90MTRS) | 2.5 mm² | MST | RETAIL | COILS
X13 | MULTISTRAND FRLS (90MTRS) | 4.0 mm² | MST | RETAIL | COILS
X14 | MULTISTRAND FRLS (90MTRS) | 6.0 mm² | MST | RETAIL | COILS
X15 | MULTISTRAND FRLS (90MTRS) | 10.0 mm² | MST | RETAIL | COILS
X16 | FLEXIBLE | 14/60 | MST-FLEXIBLE | RETAIL | COILS
X17 | FLEXIBLE | 23/60 | MST-FLEXIBLE | RETAIL | COILS
X18 | FLEXIBLE | 40/60 | MST-FLEXIBLE | RETAIL | COILS
X19 | CONCENTRIC | 4.0 mm² | C/C | RETAIL | MTRS
X20 | CONCENTRIC | 5.0 mm² | C/C | RETAIL | MTRS
X21 | CONCENTRIC | 6.0 mm² | C/C | RETAIL | MTRS
X22 | CONCENTRIC | 10.0 mm² | C/C | RETAIL | MTRS
X23 | CONCENTRIC | 16.0 mm² | C/C | RETAIL | MTRS
X24 | ACSR | WEASEL | ACSR | PROJECT | KM
X25 | ACSR | RABBIT | ACSR | PROJECT | KM
[NAME] | ACSR | DOG | ACSR | PROJECT | KM
X27 | ACSR | [NAME] | ACSR | PROJECT | KM
X28 | ACSR | PANTHER | ACSR | PROJECT | KM
X29 | ACSR | BEAR | ACSR | PROJECT | KM
X30 | ACSR | BISON | ACSR | PROJECT | KM
X31 | ACSR | ZEBRA | ACSR | PROJECT | KM
X32 | ACSR | CARDINAL | ACSR | PROJECT | KM
X33 | ACSR | MOOSE | ACSR | PROJECT | KM
X34 | ACSR |  | ACSR | PROJECT | KM
X35 | ACSR |  | ACSR | PROJECT | KM
X36 | ACSR |  | ACSR | PROJECT | KM
X37 |  | TOTAL |  |  | KM
X38 | ABC | 1C*25 mm²+1C*25 mm² | ABC | PROJECT | KM
X39 | ABC | 3C*25 mm²+1C*25 mm² | ABC | PROJECT | KM
X40 | ABC | 3C*50 mm²+1C*35 mm² | ABC | PROJECT | KM
X41 | ABC | 3C*95 mm²+1C*70 mm² | ABC | PROJECT | KM
X42 | ABC | 3C*120 mm²+1C*70 mm² | ABC | PROJECT | KM
X43 | ABC | 3C*150 mm²+1C*70 mm² | ABC | PROJECT | KM
X44 | ABC | 2C*50 mm² | ABC | PROJECT | KM
X45 | ABC | 4C*25 mm² | ABC | PROJECT | KM
X46 | ABC | 4C*50 mm² | ABC | PROJECT | KM
X47 | ABC | 4C*95 mm² | ABC | PROJECT | KM
X48 | ABC
X49 | ABC
X50 | ABC
X51 | SEC | 9 SWG | SEC | PROJECT | KGS
X52 | SEC | 10SWG | SEC | PROJECT | KGS
X53 | SEC | 11 SWG | SEC | PROJECT | KGS
X54 | SEC | 11.5 SWG | SEC | PROJECT | KGS
X55 | SEC | 12 SWG | SEC | PROJECT | KGS
X56 | SEC | 12.5 SWG | SEC | PROJECT | KGS
X57 | SEC | 13 SWG | SEC | PROJECT | KGS
X58 | SEC | 13.5 SWG | SEC | PROJECT | KGS
X59 | SEC | 14 SWG | SEC | PROJECT | KGS
X60 | SEC | 14.5 SWG | SEC | PROJECT | KGS
X61 | SEC | 15 SWG | SEC | PROJECT | KGS
X62 | SEC | 15.5 SWG | SEC | PROJECT | KGS
X63 | SEC | 16 SWG | SEC | PROJECT | KGS
X64 | SEC | 16.5 SWG | SEC | PROJECT | KGS
X65 | SEC | 17 SWG | SEC | PROJECT | KGS
X66 | SEC | 17.5 SWG | SEC | PROJECT | KGS
X67 | SEC | 18 SWG | SEC | PROJECT | KGS
X68 | SEC | 18.5 SWG | SEC | PROJECT | KGS
X69 | SEC | 19 SWG | SEC | RETAIL | KGS
X70 | SEC | 19.5 SWG | SEC | PROJECT | KGS
X71 | SEC | 20 SWG | SEC | PROJECT | KGS
X72 | SEC | 20.5 SWG | SEC | RETAIL+PROJECT | KGS
X73 | SEC | 21 SWG | SEC | RETAIL | KGS
X74 | SEC | 21.5 SWG | SEC | RETAIL | KGS
X75 | SEC | 22 SWG | SEC | RETAIL | KGS
X76 | SEC | 22.5 SWG | SEC | RETAIL | KGS
X77 | SEC | 23 SWG | SEC | RETAIL | KGS
X78 | SEC | 24 SWG | SEC | RETAIL | KGS
X79 | SEC | 25 SWG | SEC | RETAIL | KGS
X80 | SEC | 26 SWG | SEC | RETAIL | KGS
X81 | SEC | 27 SWG | SEC | RETAIL | KGS
X82 | SEC | 28 SWG | SEC | RETAIL | KGS
X83 | SEC | 29 SWG | SEC | RETAIL | KGS
X84 | SEC | 30 SWG | SEC | RETAIL | KGS
X85 | SEC | 31 SWG | SEC | RETAIL | KGS
X86 | SEC | 32 SWG | SEC | RETAIL | KGS
X87 | SEC | 33 SWG | SEC | RETAIL | KGS
X88 | SEC | 34 SWG | SEC | RETAIL | KGS
X89 | SEC | 35 SWG | SEC | RETAIL | KGS
[NAME] | SEC | 36 SWG | SEC | RETAIL | KGS
X91 | STRIP | 2.0 mm * 8.5 mm | TPC | PROJECT | KGS
X92 | STRIP | 4.5 mm * 7.0 mm | TPC | PROJECT | KGS
X93 | STRIP | 2.1 mm * 8.5 mm | TPC | PROJECT | KGS
X94 | STRIP | 2.5 mm * 2.5 mm | ROUND | PROJECT | KGS
X95 | STRIP | 4.0 mm * 8.0 mm | TPC | PROJECT | KGS
X96 | STRIP | 3.0 mm* 10.5 mm | TPC | PROJECT | KGS
X97 | STRIP | 2.5 mm * 6.5 mm | ROUND | PROJECT | KGS
X98 | STRIP | 1.5 mm * 6.4 mm | TPC | PROJECT | KGS
X99 | STRIP | 2.5 mm * 9.8 mm | TPC | PROJECT | KGS
X100 | STRIP | 3.0 mm * 9.0 mm | TPC | PROJECT | KGS
X101 | STRIP | 4.0 mm * 9.0 mm | TPC | PROJECT | KGS
X102 | STRIP | 2.5 mm * 3.65 mm | ROUND | PROJECT | KGS
X103 | STRIP | 3.0 mm * 8.0 mm | TPC | PROJECT | KGS
X104 | STRIP | 3.0 mm * 12.0 mm | TPC | PROJECT | KGS
X105 | STRIP | 4.06 mm * 2.5 mm | ROUND | PROJECT | KGS
X106 | STRIP | 2.5 * 4.06 mm | ROUND | PROJECT | KGS
X107 | STRIP
X108 | STRIP
X109 | STRIP
X110 | STRIP
X111 | STRIP
X112 | POWER CABLE | 4C*150 mm² | AL/ARM | STOCK | KM
X113 | POWER CABLE | 3.5C*240 mm² | AL/ARM | STOCK | KM
X114 | POWER CABLE | 4C*35 mm² | AL/ARM | STOCK | KM
X115 | POWER CABLE | 4C*95 mm² | AL/ARM | STOCK | KM
X116 | POWER CABLE | 4C*16 mm² | AL/UNARM | STOCK | KM
X117 | POWER CABLE | 4C*25 mm² | AL/UNARM | STOCK | KM
X118 | POWER CABLE | 3.5C*25 mm² | AL/UNARM | STOCK | KM
X119 | POWER CABLE | 3.5C*35 mm² | AL/UNARM | STOCK | KM
X120 | POWER CABLE | 4C*35 mm² | AL/UNARM | STOCK | KM
X121 | POWER CABLE | 4C*50 mm² | AL/UNARM | STOCK | KM
X122 | POWER CABLE | 4C*70 mm² | AL/UNARM | STOCK | KM
X123 | POWER CABLE | 4C*16 mm² | CU/UNARM | STOCK | KM
X124 | POWER CABLE | 4C*120 mm² | AL/ARM | STOCK | KM
X125 | POWER CABLE | 2C*1.0 mm² | CU/FLEX | RETAIL | KM
X126 | POWER CABLE | 2C*1.5 mm² | CU/FLEX | RETAIL | KM
X127 | POWER CABLE | 2C*0.75 mm² | CU/FLEX | RETAIL | KM
X128 | POWER CABLE | 3.5C*185 mm² | AL/UNARM | RETAIL | KM
X129 | POWER CABLE | 2C*1.5 mm² | CU/ARM | RETAIL | KM
X130 | POWER CABLE | 4C*2.5 mm² | CU/ARM | RETAIL | KM
X131 | POWER CABLE | 2C*16 mm² | CU/ARM | RETAIL | KM
X132 | POWER CABLE | 4C*16 mm² | CU/ARM | RETAIL | KM
X133 | POWER CABLE | 25C*1.5 mm² | CU/ARM | RETAIL | KM
X134 | POWER CABLE | 16C*1.5 mm² | CU/ARM | RETAIL | KM
X135 | POWER CABLE | 8C*1.5 mm² | CU/ARM | RETAIL | KM
X136 | POWER CABLE | 4C*25 mm² | CU/ARM | RETAIL | KM
X137 | POWER CABLE | 5C*1.5 mm² | CU/ARM | RETAIL | KM
X138 | POWER CABLE | 2C*10 mm² | CU/ARM | RETAIL | KM
X139 | POWER CABLE | 3.5C*300 mm² | AL/ARM | STOCK | KM
X140 | POWER CABLE |  |  |  | KM
X141 | POWER CABLE |  |  |  | KM
X142 | POWER CABLE |  |  |  | KM
X143 | [NAME] (90MTRS) | 0.75 mm² | MST | RETAIL | COILS
X144 | [NAME] (90MTRS) | 1.0 mm² | MST | RETAIL | COILS
X145 | [NAME] (90MTRS) | 1.5 mm² | MST | RETAIL | COILS
X146 | [NAME] (90MTRS) | 2.5 mm² | MST | RETAIL | COILS
X147 | [NAME] (90MTRS) | 4.0 mm² | MST | RETAIL | COILS
X148 | [NAME] (90MTRS) | 6.0 mm² | MST | RETAIL | COILS
X149 | [NAME] (90MTRS) | 10.0 mm² | MST | RETAIL | COILS
X150 | MULTISTRAND FR (45mtrs) | 0.75 mm² | MST | RETAIL | COILS
X151 | MULTISTRAND FR (45mtrs) | 1.0 mm² | MST | RETAIL | COILS
X152 | MULTISTRAND FR (45mtrs) | 1.5 mm² | MST | RETAIL | COILS
X153 | MULTISTRAND FR (45mtrs) | 2.5 mm² | MST | RETAIL | COILS
X154 | MULTISTRAND FR (45mtrs) | 4.0 mm² | MST | RETAIL | COILS
X155 | MULTISTRAND FR (45mtrs) | 6.0 mm² | MST | RETAIL | COILS
X156 | MULTISTRAND FR (45mtrs) | 10.0 mm² | MST | RETAIL | COILS
X157 | MULTISTRAND FR (45mtrs) | 16.0 mm² | MST | RETAIL | COILS
X158 | MULTISTRAND FRLS (45mtrs) | 0.75 mm² | MST | RETAIL | COILS
X159 | MULTISTRAND FRLS (45mtrs) | 1.0 mm² | MST | RETAIL | COILS
X160 | MULTISTRAND FRLS (45mtrs) | 1.5 mm² | MST | RETAIL | COILS
X161 | MULTISTRAND FRLS (45mtrs) | 2.5 mm² | MST | RETAIL | COILS
X162 | MULTISTRAND FRLS (45mtrs) | 4.0 mm² | MST | RETAIL | COILS
X163 | MULTISTRAND FRLS (45mtrs) | 6.0 mm² | MST | RETAIL | COILS
X164 | MULTISTRAND FRLS (45mtrs) | 10.0 mm² | MST | RETAIL | COILS
X165 | [NAME] (45mtrs) | 0.75 mm² | MST | RETAIL | COILS
X166 | [NAME] (45mtrs) | 1.0 mm² | MST | RETAIL | COILS
X167 | [NAME] (45mtrs) | 1.5 mm² | MST | RETAIL | COILS
X168 | [NAME] (45mtrs) | 2.5 mm² | MST | RETAIL | COILS
X169 | [NAME] (45mtrs) | 4.0 mm² | MST | RETAIL | COILS
X170 | [NAME] (45mtrs) | 6.0 mm² | MST | RETAIL | COILS
X171 | [NAME] (45mtrs) | 10.0 mm² | MST | RETAIL | COILS
X172 | MULTISTRAND FR (180mtrs) | 0.75 mm² | MST | RETAIL | COILS
X173 | MULTISTRAND FR (180mtrs) | 1.0 mm² | MST | RETAIL | COILS
X174 | MULTISTRAND FR (180mtrs) | 1.5 mm² | MST | RETAIL | COILS
X175 | MULTISTRAND FR (180mtrs) | 2.5 mm² | MST | RETAIL | COILS
X176 | MULTISTRAND FR (180mtrs) | 4.0 mm² | MST | RETAIL | COILS
X177 | MULTISTRAND FR (180mtrs) | 6.0 mm² | MST | RETAIL | COILS
X178 | MULTISTRAND FR (180mtrs) | 10.0 mm² | MST | RETAIL | COILS
X179 | MULTISTRAND FR (180mtrs) | 16.0 mm² | MST | RETAIL | COILS
X180 | [NAME] (180mtrs) | 0.75 mm² | MST | RETAIL | COILS
X181 | [NAME] (180mtrs) | 1.0 mm² | MST | RETAIL | COILS
X182 | [NAME] (180mtrs) | 1.5 mm² | MST | RETAIL | COILS
X183 | [NAME] (180mtrs) | 2.5 mm² | MST | RETAIL | COILS
X184 | [NAME] (180mtrs) | 4.0 mm² | MST | RETAIL | COILS
X185 | [NAME] (180mtrs) | 6.0 mm² | MST | RETAIL | COILS
X186 | [NAME] (180mtrs) | 10.0 mm² | MST | RETAIL | COILS
X187 | [NAME] (180mtrs) | 0.75 mm² | MST | RETAIL | COILS
X188 | [NAME] (180mtrs) | 1.0 mm² | MST | RETAIL | COILS
X189 | [NAME] (180mtrs) | 1.5 mm² | MST | RETAIL | COILS
X190 | [NAME] (180mtrs) | 2.5 mm² | MST | RETAIL | COILS
X191 | [NAME] (180mtrs) | 4.0 mm² | MST | RETAIL | COILS
X192 | [NAME] (180mtrs) | 6.0 mm² | MST | RETAIL | COILS
X193 | [NAME] (180mtrs) | 10.0 mm² | MST | RETAIL | COILS