Spreadsheet: 677644d1589451203-help-with-finding-double-info-in-2-excel-tables-00_invoices-erp
Sheet: Sheet1

PO | Invoice nr ERP | Column1 | PAID | Total Cost | Vendor | Ordered On | Total Cases |  | [NAME] | Amount
11FBTOAT | if kolom a is the same as kolom F in the first worksheet, i want to copy the ID number of the first sheet in this kolom | 18289 |  | 61.33 | TEIGE | 02/26/2020 | 13
11NH4TMS |  |  |  |  | TEIGE | 01/06/2020
1231RL1D |  | 18382 |  | 1387.62 |  | 04/20/2020
127BKCHZ |  | 18295 |  | 65.58 | TEIGE | 02/26/2020 | 16
136O145I |  |  |  |  | TEIGE | 01/30/2020
14WXSMAV |  | 18009 | 121488811 | 657.55 | TEIGE | 01/09/2020 | 62
17YQNTER |  |  |  |  | TEIGE | 01/06/2020
1DDVTAGK |  |  |  |  | TEIGE | 01/09/2020
1I4Q3QML |  |  |  |  | TEIGE | 01/23/2020
1JGP9W4K |  | 18291 |  | 25.04 | TEIGE | 02/26/2020 | 7
1N1XODDS |  | 18387 |  | 535.92 |  | 04/20/2020
1OZZ38OD |  | 18285 |  | 12.12 | TEIGE | 02/26/2020 | 3
1SKQX21L |  |  |  |  | TEIGE | 01/20/2020
1URA6Q6J |  |  |  |  | TEIGE | 01/23/2020
1UV21CPZ |  | 18296 |  | 87 | TEIGE | 02/26/2020 | 20
1V68YZ1X |  | 18441 |  | 1039.32 |  | 05/04/2020
1WA167AZ |  | 18367 |  | 2964.21 |  | 02/26/2020
23O9IKWM |  | 18435 |  | 1697.84 |  | 05/04/2020
25C6YAMW |  |  |  |  | TEIGE | 03/09/2020
28C5YAPG |  | 18384 |  | 595.04 |  | 04/20/2020
2AMCG3RA |  | 18410 |  | 121.85 |  | 04/27/2020
2AY6L6DW |  |  |  |  | TEIGE | 02/17/2020
2BYKRQ3K |  |  |  |  | TEIGE | 02/13/2020
2CNHQ6XL |  |  |  |  | TEIGE | 02/17/2020
2D6X8W1G |  | 18069 | 123099542 | 531.35 | TEIGE | 01/23/2020 | 12
2DYZEQGT |  |  |  |  | TEIGE | 02/13/2020
2E173ZHW |  |  |  |  | TEIGE | 02/06/2020
2GCZXENP |  |  |  |  | TEIGE | 02/17/2020
2H7EIQPI |  | 18198 |  | 216.15 | TEIGE | 02/05/2020 | 3
2HCMF1RO |  | 18203 |  | 865.08 |  | 02/05/2020
2I7RJIIE |  |  |  |  | TEIGE | 02/17/2020
2PZFJ7IX |  |  |  |  | TEIGE | 02/10/2020
2QIAPVQU |  |  |  |  | TEIGE | 02/06/2020
2QQYO3GI |  | 18199 |  | 144.1 | TEIGE | 02/05/2020 | 2
2WJFAJ6H |  |  |  |  | TEIGE | 02/10/2020
2Z8RXYJZ |  | 18202 |  | 72.05 | TEIGE | 02/05/2020 | 1
2Z9O8LRI |  | 18050 | 121828540 | 479.59 | TEIGE | 01/20/2020 | 80
3615ZUZD |  |  |  | 26.96 |  | 03/04/2020
3617HP2A |  | 18196 |  | 24.3 | TEIGE | 02/05/2020 | 5
37F6EL7O |  |  |  |  | TEIGE | 01/27/2020
3996K6DG |  | 18436 |  | 564 |  | 05/04/2020
3A1GCV6K |  | 18440 |  | 26.96 |  | 03/04/2020
3JO6CIZL |  | 18430 |  | 511.1 |  | 05/04/2020
3K2943NN |  | 18334 |  | 53.92 |  | 03/04/2020
3LVZP7IC |  |  |  | 53.92 |  | 03/04/2020
3TH9OV9I |  |  |  |  | TEIGE | 01/23/2020
3TLUQ9GK |  | 18197 |  | 4.86 | TEIGE | 02/05/2020 | 1
3TVB3Y3L |  | 18023 | 123069711 | 465.82 | TEIGE | 01/13/2020 | 5
3XE2HDVJ |  |  |  | 1262.52 |  | 04/20/2020
3ZACH11H |  |  |  |  | TEIGE | 01/16/2020
3ZIE8HWL |  |  |  | 411.62 |  | 04/06/2020
41DZYX2F |  | 18124 |  | 308 | TEIGE | 02/10/2020 | 64
41HCS9SJ |  | 18201 |  | 72.05 | TEIGE | 02/05/2020 | 1
41UZ5GDX |  |  |  |  | TEIGE | 02/03/2020
423BNZ3H |  |  |  | 53.92 |  | 03/04/2020
45YR2TVL |  |  |  | 81.36 |  | 02/26/2020
4CB1LTNK |  |  |  | 3.23 |  | 02/26/2020
4FW38O1H |  |  |  |  | TEIGE | 02/03/2020
4JDOBU3P |  |  |  | 1039.32 |  | 04/23/2020
4NUHQ5EE |  | 17994 | 121488811 | 1730.05 | TEIGE | 01/06/2020 | 176
4OS58PWI |  |  |  | 17.41 |  | 02/26/2020
4RDRW7XM |  |  |  |  | TEIGE | 01/30/2020
4RW7P1YN |  | 18125 |  | 601.93 | TEIGE | 02/10/2020 | 5
4UMAU5RM |  | 18200 |  | 144.1 | TEIGE | 02/05/2020 | 2
4Z4P4PUO |  |  |  | 4.04 |  | 02/26/2020
52ASRS4Q |  | 18290 |  | 24.23 | TEIGE | 02/26/2020 | 7
532SIGBW |  | 18284 |  | 1079.77 | TEIGE | 02/26/2020 | 276
5AX2IRHH |  | 18288 |  | 4.46 | TEIGE | 02/26/2020 | 1
5C3O2MOK |  | 18206 |  | 458.91 | TEIGE | 02/27/2020 | 41
5EMKPZ7L |  | 18287 |  | 7.72 | TEIGE | 02/26/2020 | 1
5GHCC42A |  | 18286 |  | 4.04 | TEIGE | 02/26/2020 | 1
5GXYO98U |  |  |  |  | TEIGE | 02/17/2020
5I8YZYHT |  | 18100 |  | 502.84 | TEIGE | 02/03/2020 | 63
5K1F38HE |  | 18293 |  | 25.13 | TEIGE | 02/26/2020 | 5
5MR45WJT |  | 18110 |  | 520.88 | TEIGE | 02/06/2020 | 4
5Q9GARDJ |  | 18157 |  | 548.54 | TEIGE | 02/13/2020 | 6
5RVO3JNP |  | 18283 |  | 266.44 | TEIGE | 02/26/2020 | 64
5UIFFBPK |  | 18294 |  | 27.07 | TEIGE | 02/26/2020 | 8
5UIU6L5B |  |  |  |  | TEIGE | 02/17/2020
65X1K5VI |  |  |  |  | TEIGE | 01/13/2020
6BP5A5QQ |  | 18111 |  | 96.06 | TEIGE | 02/06/2020 | 1
6E8MYOPV |  |  |  |  | TEIGE | 01/20/2020
6EY2I77A |  |  |  |  | TEIGE | 01/30/2020
6EZ1JT8Z |  | 18089 |  | 520.88 | TEIGE | 01/30/2020 | 4
6GKDKXAR |  |  |  |  | TEIGE | 01/13/2020
6H8WLR5T |  |  |  | 672.12 |  | 04/20/2020
6JGXJLEY |  | 18070 | 123099542 | 500.46 | TEIGE | 01/23/2020 | 75
6MFN8Q9A |  | 18158 |  | 425.25 | TEIGE | 02/13/2020 | 32
6NT6K43C |  | 18038 | 123069711 | 522.43 | TEIGE | 01/16/2020 | 6
6OFML9GC |  |  |  |  | TEIGE | 01/13/2020
6QCDKJ6Z |  | 18267 |  | 548.54 | TEIGE | 03/12/2020 | 6
6TZMS6QJ |  | 18204 |  | 1224.85 | TEIGE | 02/05/2020 | 17
6V6DWX4D |  |  |  | 503.68 |  | 04/30/2020
6Y4S11EB |  |  |  |  | TEIGE | 01/20/2020
7228X1NE |  | 18159 |  | 482.52 | TEIGE | 02/13/2020 | 60
72LQP1HD |  | 18264 |  | 503.56 | TEIGE | 03/09/2020 | 91
7AAOFRXM |  |  |  | 346.44 |  | 04/06/2020
7AEX4SFZ |  |  |  | 489.58 |  | 04/23/2020
7F22CI9M |  |  |  |  | TEIGE | 02/10/2020
7GVSXM4B |  |  |  |  | TEIGE | 02/10/2020
7IW7XK7A |  | 18252 |  | 507.84 | TEIGE | 03/05/2020 | 35
7LRJG4UM |  |  |  | 26.96 |  | 03/04/2020
7S1AQ8BA |  |  |  |  |  | 04/06/2020
7SYOQ5IB |  |  |  | 341.87 |  | 04/30/2020
7X928GVY |  |  |  | 692.88 |  | 04/27/2020
7ZP74I5Y |  |  |  |  | TEIGE | 02/10/2020
816MQCWD |  |  |  |  | TEIGE | 02/13/2020
81B3GOXL |  | 18101 |  | 506.33 | TEIGE | 02/03/2020 | 63
82PVS28O |  |  |  |  | TEIGE | 01/27/2020
842X4W2U |  |  |  | 14.54 |  | 02/26/2020
85XWT1AQ |  |  |  |  | TEIGE | 02/13/2020
87B8Q91V |  |  |  | 22.64 |  | 02/26/2020
88KXQ69K |  |  |  |  | TEIGE | 01/27/2020
8A5LYVHM |  |  |  |  | TEIGE | 01/16/2020
8DMIA8SU |  |  |  | 113.6 |  | 02/26/2020
8EGRT7JU |  |  |  | 692.88 |  | 04/20/2020
8F7ZEXHM |  |  |  |  | TEIGE | 01/27/2020
8GDF23WE |  |  |  | 510.77 |  | 04/20/2020
8HMSM8YB |  |  |  | 71.67 |  | 02/26/2020
8K9JY11W |  |  |  | 8.08 |  | 02/26/2020
8NU1NOGK |  |  |  |  | TEIGE | 02/03/2020
8QKTHZSV |  |  |  | 16.96 |  | 02/26/2020
8RLY46ZH |  | 18037 | 121863666 | 501.73 | TEIGE | 01/16/2020 | 77
8SQD8W4N |  |  |  | 210.68 |  | 02/26/2020
8V62NJJW |  |  |  | 2151.36 |  | 04/27/2020
8VTZEY6K |  | 18195 |  | 502.4 | TEIGE | 02/24/2020 | 41
8WJ1XA1D |  |  |  |  | TEIGE | 02/03/2020
8Y97ZGLF |  |  |  | 192.29 |  | 04/27/2020