Spreadsheet: 767005d1644232693-return-a-qty-and-ref-code-as-per-lookup-criteria-in-column-a-return-qty-and-ref
Sheet: Sheet1

Item Code | Item Description |  | Expected Results |  |  |  |  |  | Item Code | Item Description | Kolumna1 | Kolumna2 | HDR-2011/2313 | HDR-2011/2333 | HDR-2012/2337 | HDR-2011/2312 | HDR-2011/2334 | HDR-2012/2359 | HDR-2101/2422 | HDR-2101/2437+2438 | HDR-2102/2454 | HDR-2101/2426 | Kolumna3 | HDR-2102/2447 |  | Item Code | Item Description | Qty | REf Code
 |  |  | Qty | Ref# Code |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9366 | Shore Brace Frame (H) | 14 | HDR-2011/2333
9366 | Shore Brace Frame (H) |  | 14 | HDR-2011/2333 |  |  |  |  | 9366 | Shore Brace Frame (H) |  |  |  | 14 | 82 |  |  |  |  |  |  |  |  | 39 |  | 9366 | Shore Brace Frame (H) | 82 | HDR-2012/2337
25915 | U-Head [NAME] W=18[NAME] (2.0'') (Galv) |  | 50 | HDR-2011/2333 |  |  |  |  | 25915 | U-Head [NAME] W=18[NAME] (2.0'') (Galv) |  |  |  | 50 | 65 |  |  | 6 |  |  |  |  |  |  |  | 9366 | Shore Brace Frame (H) | 39 | HDR-2102/2447
25915 | U-Head [NAME] W=18[NAME] (2.0'') (Galv) |  | 65 | HDR-2012/2359 |  |  |  |  | 13141 | Post head [NAME] (2.0'') (L) ([NAME].) |  |  |  | 115 | 38 |  | 74 | 7 | 137 |  | 178 |  |  | 421 |  | 25915 | U-Head [NAME] W=18[NAME] (2.0'') (Galv) | 50 | HDR-2011/2333
9366 | Shore Brace Frame (H) |  | 82 | HDR-2102/2447 |  |  |  |  | 141516 | Cross Brace 0.90m |  |  |  |  |  | 62 |  |  |  | 15 |  |  |  |  |  | 25915 | U-Head [NAME] W=18[NAME] (2.0'') (Galv) | 65 | HDR-2012/2337
13141 | Post head [NAME] (2.0'') (L) ([NAME].) |  | 115 | HDR-2011/2333 |  |  |  |  | 141523 | Cross Brace 1.20m |  |  | 55 |  |  |  |  |  |  |  |  |  |  |  |  | 25915 | U-Head [NAME] W=18[NAME] (2.0'') (Galv) | 6 | HDR-2012/2359
25915 | U-Head [NAME] W=18[NAME] (2.0'') (Galv) |  | 6 | HDR-2012/2337 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13141 | Post head [NAME] (2.0'') (L) ([NAME].) | 115 | HDR-2011/2333
13141 | Post head [NAME] (2.0'') (L) ([NAME].) |  | 38 | HDR-2012/2337 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13141 | Post head [NAME] (2.0'') (L) ([NAME].) | 38 | HDR-2012/2337
13141 | Post head [NAME] (2.0'') (L) ([NAME].) |  | 74 | HDR-2011/2334 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13141 | Post head [NAME] (2.0'') (L) ([NAME].) | 74 | HDR-2011/2334
13141 | Post head [NAME] (2.0'') (L) ([NAME].) |  | 7 | HDR-2012/2359 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13141 | Post head [NAME] (2.0'') (L) ([NAME].) | 7 | HDR-2012/2359
141516 | Cross Brace 0.90m |  | 62 | HDR-2011/2312 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13141 | Post head [NAME] (2.0'') (L) ([NAME].) | 137 | HDR-2101/2422
13141 | Post head [NAME] (2.0'') (L) ([NAME].) |  | 137 | HDR-2101/2422 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13141 | Post head [NAME] (2.0'') (L) ([NAME].) | 178 | HDR-2102/2454
141516 | Cross Brace 0.90m |  | 15 | HDR-2101/2437+2438 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13141 | Post head [NAME] (2.0'') (L) ([NAME].) | 421 | HDR-2102/2447
13141 | Post head [NAME] (2.0'') (L) ([NAME].) |  | 178 | HDR-2102/2454 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 141516 | Cross Brace 0.90m | 62 | HDR-2011/2312
9366 | Shore Brace Frame (H) |  | 39 | HDR-2012/2337 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 141516 | Cross Brace 0.90m | 15 | HDR-2101/2437+2438
141523 | Cross Brace 1.20m |  | 55 | HDR-2011/2313 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 141523 | Cross Brace 1.20m | 55 | HDR-2011/2313
13141 | Post head [NAME] (2.0'') (L) ([NAME].) |  | 421 | HDR-2102/2447