Spreadsheet: 115450d1311068713-copy-vlookup-help-vlookup-test-1-
Sheet: Sheet1

System | Part Description | Part no | Stock Code | Qty sent | Price (1) |  |  |  | Qty | Price |  | Stock Code | Part Number | Qty ordered | Price (2)
Housing | Part 1 | 1291613 | EIS00006 | 200 | 12.48 |  |  |  |  |  |  |  | 1239377 | 10 | 1.87
Housing | Part 2 | 1295667 | ILS00015 | 100 | 2.15 |  |  |  |  |  |  | UCS00618 | 1248404 | 3 | 57.94
Housing | Part 3 | 1295669 | ILS00017 | 100 | 2.51 |  |  |  |  |  |  | CTS00343 | 1256778 | 2 | 412.4
Housing | Part 4 | 1295670 | ILS00014 | 100 | 2.15 |  |  |  |  |  |  |  | 1258642 | 1 | 53.41
Housing | Part 5 | 1295671 | ILS00018 | 100 | 2.51 |  |  |  |  |  |  | CTS00608 | 1262189 | 2 | 593.14
Housing | Part 6 | 1295672 | ILS00016 | 100 | 2.51 |  |  |  |  |  |  | CTS00609 | 1262190 | 2 | 593.14
Housing | Part 7 | 1300933 | AVS00512 | 8 | 76.46 |  |  |  |  |  |  |  | 1264606 | 5 | 15.12
Housing | Part 8 | 1303469 | CTS00605 | 2 | 426.89 |  |  |  |  |  |  | HCS00047 | 1264995 | 1 | 695.62
Housing | Part 9 | 1305193 | OSS00520 | 10 | 36.05771265000001 |  |  |  |  |  |  |  | 1265126 | 1 | 554.86
Housing | Part 10 | 1312790 | PBS00102 | 1 | 2212.89276 |  |  |  |  |  |  | HCS00335 | 1265164 | 1 | 6.65
Housing | Part 11 | 1315495 | AVS00515 | 4 | 206.31 |  |  |  |  |  |  |  | 1279021 | 10 | 0.79
Housing | Part 12 | [PHONE] | XRS00002 | 2 | 654.59 |  |  |  |  |  |  |  | 1287743 | 2 | 6055.99
Housing | Part 13 | 1319248 | CTS00604 | 2 | 426.89 |  |  |  |  |  |  |  | 1289995 | 10 | 0.44
Housing | Part 14 | 1345060 | WVS00307 | 5 | 81.02 |  |  |  |  |  |  |  | 1300933 | 8 | 75.7
Housing | Part 15 | 1345061 | [NAME] | 5 | 81.02 |  |  |  | 2 | 426.89 |  | CTS00605 | 1303469 | 2 | 426.89
Housing | Part 16 | 1345062 | WVS00304 | 1 | 81.02 |  |  |  |  |  |  |  | 1312790 | 1 | 2212.89
Housing | Part 17 | 1345063 | WVS00306 | 1 | 81.02 |  |  |  |  |  |  |  | 1313463 | 10 | 0.65
Housing | Part 18 | 1345079 | WVS00301 | 4 | 70.22 |  |  |  |  |  |  |  | 1315495 | 2 | 698.81
Housing | Part 19 | 1345083 | WPS00304 | 30 | 3.44 |  |  |  | 2 | 426.89 |  | CTS00604 | 1319248 | 2 | 426.89
Housing | Part 20 | 1345085 | WPS00306 | 10 | 37.15 |  |  |  | 1 | 81.02 |  | WVS00304 | 1345062 | 5 | 81.02
Housing | Part 21 | [PHONE] | JSS00411 | 2 | 8576.21 |  |  |  | 4 | 70.22 |  | WVS00301 | 1345079 | 5 | 70.22
Housing | Part 22 | 1345278 | WVS00302 | 1 | 83.97 |  |  |  | 1 | 83.97 |  | WVS00302 | 1345278 | 5 | 83.97
Housing | Part 23 | 1345279 | [NAME] | 1 | 197.72 |  |  |  | 1 | 13.59 |  | WVS00303 | 1345521 | 20 | 13.59
Housing | Part 24 | 1345521 | WVS00303 | 1 | 13.59 |  |  |  | 2 | 206.31 |  | BVS00611 | 1354245 | 2 | 204.27
Housing | Part 25 | 1345704 | WLS00600 | 10 | 43.54 |  |  |  |  |  |  |  | 1355685 | 1 | 204.59
Housing | Part 26 | 1345705 | WPS00303 | 10 | 28.97 |  |  |  | 40 | 6.38 |  | [NAME] | 1358086 | 40 | 6.38
Housing | Part 27 | 1348533 | PAS00308 | 3 | 1055.72 |  |  |  |  |  |  |  | 1374419 | 4 | 357.71
Housing | Part 28 | 1353537 | SXS00004 | 2 | 87.1 |  |  |  |  |  |  |  | 1375142 | 200 | 0.57
Housing | Part 29 | 1353538 | EPS00103 | 2 | 74 |  |  |  |  |  |  | OSS00502 | 1375202 | 100 | 0.36
Housing | Part 30 | 1354245 | BVS00611 | 2 | 206.31 |  |  |  |  |  |  |  | 1375294 | 100 | 1.57
Housing | Part 31 | 1355685 | PBS00101 | 1 | 204.594375 |  |  |  |  |  |  |  | 1375297 | 100 | 4.81
Housing | Part 32 | 1358086 | [NAME] | 40 | 6.38 |  |  |  |  |  |  |  | 1375345 | 100 | 3.26
Housing | Part 33 | 1360620 | TGS00029 | 4 | 81.34180590717298 |  |  |  |  |  |  |  | 1375385 | 50 | 1.93
Housing | Part 34 | 1368863 | PKS00419 | 1 | 1391.37 |  |  |  |  |  |  |  | 1383932 | 2 | 77.55
Housing | Part 35 | 1374419 | AVS00516 | 4 | 361.29 |  |  |  |  |  |  | [NAME] | 1390651 | 1 | 16.37
Housing | Part 36 | 1375142 | [NAME] | 200 | 0.57 |  |  |  |  |  |  |  | 1395572 | 4 | 125.54