Spreadsheet: 848038d1698846871-help-with-index-match-or-whatever-can-work-please-excelforum-sample
Sheet: Receiving Coy Data

Value | Receiving Coy Ref Number | Qty
1998 | 7297 | 120
61195.96 | 7298 | 76
4583.37 | 7299 | 11
2820 | 7300 | 6
4401.76 | 7301 | 2
27300 | 7302 | 9
21266.63 | 7308 | 11
30474.54 | 7309 | 138
2208.3 | 7310 | 10
54871.93 | 7312 | 241
90441.94 | 7324 | 642
1271.25 | 7326 | 1
895.71 | 7327 | 1
27570.55 | 7328 | 121
30309.54 | 7329 | 33
142.42 | 7347 | 1
12000 | 7348 | 12
117022.75 | 7349 | 65
12395.74 | 7351 | 28
5500 | 7352 | 1
42895.36 | 7353 | 142
388.32 | 7354 | 1
1301.3 | 7355 | 10
679 | 7356 | 1
15500 | 7357 | 4
6555.6 | 7358 | 40
56330.4 | 7359 | 720
5266.68 | 7371 | 4
7575 | 7372 | 15
9000 | 7373 | 100
29096.4 | 7374 | 696
6624.9 | 7381 | 30
9100 | 7382 | 14
27256.8 | 7407 | 120
7036 | 7408 | 56
28899.96 | 7417 | 12
26961 | 7429 | 16
15000 | 7435 | 6
131425.68 | 7436 | 42
6600 | 7437 | 24
3300 | 7438 | 24
3600 | 7439 | 48
32595.01 | 7440 | 36
38557.98 | 7441 | 18
18416.71 | 7454 | 13
500 | 7459 | 1
19874.64 | 7467 | 84
6249.6 | 7474 | 120
1400.64 | 7475 | 4
2276.12 | 7476 | 2
131994.39 | 7482 | 163
5672.79 | 7483 | 4
23249.4 | 7486 | 190
8600.04 | 7511 | 12
21199.68 | 7512 | 96
569.58 | 7513 | 2
12861.44 | 7514 | 24
5900.04 | 7515 | 36
16200 | 7516 | 12
36056.04 | 7517 | 12
4074.99 | 7518 | 3
49249.2 | 7519 | 240
2258.37 | 7521 | 12
1200 | 7522 | 1
240 | 7523 | 4
17080.2 | 7547 | 84
4116 | 7563 | 6
5900.04 | 7574 | 36
11520 | 7575 | 6
2280 | 7576 | 12
43200 | 7577 | 240
14000.04 | 7599 | 12
3225 | 7600 | 1
5606.48 | 7601 | 8
28260.36 | 7602 | 132
10000.02 | 7603 | 7
3965.04 | 7614 | 12
4750 | 7615 | 2
2280 | 7616 | 24
30637.56 | 7617 | 18
5606.48 | 7618 | 8
145.12 | 7624 | 1
5130 | 7652 | 24
198000 | 7668 | 72
20610 | 7669 | 48
43200 | 7670 | 240
8500.08 | 7671 | 24
199.8 | 7672 | 12
5900.04 | 7673 | 36
1198.83 | 7674 | 9
3400 | 7675 | 10
10833.3 | 7676 | 10
20832.9 | 7678 | 30
23400 | 7679 | 30
4206.45 | 7680 | 1
5400 | 7689 | 6
5232.8 | 7690 | 20
1816.68 | 7691 | 6
14000.04 | 7692 | 12
16200 | 7693 | 6
33600 | 7695 | 24
399.6 | 7696 | 24
34560 | 7697 | 192
12777.8 | 7702 | 10
2555.56 | 7703 | 2
231388.45 | 7714 | 147
4750.02 | 7715 | 24
1083.36 | 7716 | 6
26430 | 7717 | 54
95300.06 | 7718 | 26
22800 | 7719 | 19
269040.92 | 7720 | 179
783.33 | 7721 | 1
21600 | 7722 | 120
399.6 | 7723 | 24
33600 | 7724 | 24
50399.89 | 7738 | 26
237.05 | 7754 | 5
18275 | 7759 | 4
4166.58 | 7760 | 6
21600 | 7761 | 120
86032.25 | 7311 | 68
6249.99 | 7313 | 3
19999.98 | 7314 | 6
23199.96 | 7315 | 12
16800 | 7316 | 6
17415 | 7317 | 60
18705 | 7318 | 12
9450 | 7319 | 12
16354.98 | 7330 | 6
6600 | 7331 | 24
9000 | 7332 | 6
36999.96 | 7333 | 12
1230 | 7334 | 6
2580.24 | 7335 | 12
3600 | 7336 | 6
27499.98 | 7337 | 8
6000 | 7339 | 12
7999.98 | 7343 | 6
9000 | 7361 | 6
1040 | 7364 | 2
726 | 7365 | 2
4700 | 7366 | 2
49500 | 7376 | 9
20537.19 | 7377 | 93
9000 | 7383 | 6
49029.6 | 7384 | 4
19999.97 | 7385 | 19
6021.25 | 7386 | 11
22026.08 | 7387 | 88
65604.72 | 7388 | 12
16659.8 | 7389 | 7
1139.36 | 7390 | 8
2460 | 7391 | 12
31000.02 | 7392 | 12
16800 | 7393 | 6
13932 | 7394 | 48
19999.98 | 7395 | 6
2967 | 7396 | 12
4593.26 | 7410 | 2
14575 | 7411 | 53
466.68 | 7414 | 4
5000 | 7416 | 5
3483 | 7419 | 12
67666.69 | 7424 | 15
468.72 | 7425 | 9
49500 | 7428 | 9
67666.69 | 7430 | 15
209.04 | 7431 | 1
1475 | 7432 | 1
4134.45 | 7433 | 15
11000 | 7434 | 5
5299.92 | 7442 | 24
16500 | 7443 | 12
2720.16 | 7444 | 72
90300 | 7445 | 12
1500 | 7446 | 6
14333.34 | 7447 | 6
4150.02 | 7448 | 6
21285 | 7452 | 24
39501.24 | 7458 | 12
299.68 | 7460 | 1
14070 | 7461 | 10
140 | 7462 | 2
9999.99 | 7463 | 3
17415 | 7464 | 60
16320 | 7465 | 20
681.42 | 7484 | 3
24600 | 7488 | 12
5451.36 | 7489 | 24
8040 | 7490 | 4
2919.96 | 7491 | 12
9333.36 | 7492 | 6
906.72 | 7493 | 24
8000 | 7494 | 10
5299.92 | 7502 | 24
1702.08 | 7507 | 1
197985.71 | 7508 | 160
26349.92 | 7509 | 34
2149.92 | 7528 | 24
11225.04 | 7529 | 12
4532 | 7530 | 12
3300 | 7531 | 12
45150 | 7532 | 6
2460 | 7533 | 12
19999.98 | 7534 | 6
31000.02 | 7535 | 12
6000 | 7536 | 12
16800 | 7537 | 6
18705 | 7538 | 12
291.9 | 7539 | 3
8901 | 7540 | 16
1800 | 7541 | 1
4249.92 | 7542 | 24
7700 | 7543 | 104
23488.75 | 7548 | 23
17415 | 7550 | 60
4500 | 7551 | 50
3849.96 | 7552 | 12
33500 | 7553 | 10
26499.96 | 7554 | 12
2600 | 7555 | 1
4950 | 7557 | 11
6337.53 | 7558 | 9
45600 | 7578 | 12
19999.98 | 7579 | 6
31000.02 | 7580 | 12
15101.96 | 7581 | 26
6000 | 7582 | 12
3870 | 7583 | 3
8600 | 7584 | 2
9000 | 7585 | 6
33600 | 7586 | 12
3800 | 7587 | 2
8000 | 7588 | 10
3300 | 7589 | 12
31085.64 | 7590 | 15
19999.98 | 7593 | 6
906.72 | 7594 | 24
26499.96 | 7595 | 12
4320 | 7596 | 24
2460 | 7597 | 12
17200 | 7598 | 4
5670 | 7613 | 9
26877 | 7620 | 24
10000 | 7621 | 2
4269.309999999999 | 7623 | 3
32564.5 | 7625 | 20
1360.08 | 7626 | 36
1250.04 | 7627 | 12
18666.67 | 7628 | 7
9792 | 7629 | 12
3400 | 7630 | 10
3600 | 7631 | 48
8400 | 7632 | 2
1074.96 | 7633 | 12
1750 | 7634 | 5
37500.02 | 7635 | 26
28180.66 | 7636 | 43
18705 | 7653 | 12
9000 | 7654 | 6
9450 | 7655 | 12
9172.44 | 7656 | 36
27000 | 7657 | 6
116799.96 | 7658 | 24
2258.37 | 7659 | 12
17233.35 | 7660 | 11
2100 | 7661 | 3
7500 | 7662 | 3
21500 | 7663 | 5
1230 | 7664 | 6
47800.02 | 7665 | 18
24999.96 | 7666 | 12
6114.96 | 7677 | 24
3842.68 | 7698 | 17
70771.84 | 7705 | 17
2457 | 7706 | 12
24999.96 | 7707 | 12
520 | 7708 | 4
25493.16 | 7709 | 42
24999.96 | 7725 | 12
25621.84 | 7726 | 11
21600 | 7728 | 120
14870.82 | 7729 | 6
3400 | 7730 | 10
29142 | 7731 | 24
1104.2 | 7732 | 10
16920 | 7733 | 30
1650 | 7734 | 6
45150 | 7735 | 6
4500 | 7736 | 1
3600 | 7739 | 24
30511.5 | 7740 | 54
225 | 7742 | 3
35151.76 | 7743 | 10
4350 | 7748 | 3
2500 | 7749 | 5
21000 | 7750 | 6
19000.02 | 7751 | 6
17233.35 | 7752 | 11
21980 | 7753 | 122
7500 | 7755 | 3
33456.75 | 7758 | 21
468779.17 | 7293 | 1289
1800 | 7294 | 15
19500 | 7295 | 4
17500 | 7296 | 5
2250 | 7303 | 6
8500 | 7304 | 4
26470.32 | 7305 | 24
16800 | 7306 | 6
9666.66 | 7307 | 2
7041.67 | 7320 | 1
137363.14 | 7321 | 106
80135.2 | 7322 | 76
37099.44 | 7323 | 168
302.08 | 7325 | 1
10125 | 7338 | 14
3225 | 7340 | 1
3750 | 7341 | 12
3150 | 7342 | 1
45536.5 | 7344 | 22
7250.04 | 7345 | 12
8333.35 | 7346 | 5
22000 | 7350 | 10
5374.98 | 7360 | 6
18960 | 7362 | 16
42000 | 7363 | 7
3165.36 | 7367 | 41
51251.21000000001 | 7368 | 19
10000 | 7369 | 4
13750.02 | 7370 | 6
21469.42 | 7375 | 9
1500 | 7378 | 1
1666.67 | 7379 | 1
38400 | 7380 | 120
12460.41 | 7397 | 34
62648.62 | 7398 | 26
13761.28 | 7399 | 64
17468.8 | 7400 | 10
10000 | 7401 | 4
45986.15 | 7402 | 35
27862.8 | 7403 | 84
24712.55 | 7404 | 22
95100 | 7405 | 40
9460.02 | 7406 | 6
25689.97 | 7409 | 16
25784.07 | 7412 | 221
11550 | 7413 | 42
7200 | 7415 | 4
3323.07 | 7418 | 9
23220 | 7420 | 16
64810.00999999999 | 7421 | 24
2953.84 | 7422 | 8
7500 | 7423 | 1
12112.14 | 7426 | 22
9450 | 7427 | 12
27500.04 | 7449 | 12
19750.62 | 7450 | 6
13331.64 | 7451 | 12
7656.25 | 7453 | 25
220552.94 | 7455 | 971
41942.75 | 7456 | 18
34091.2 | 7457 | 10
35199.96 | 7466 | 12
1166.67 | 7468 | 1
108.33 | 7469 | 1
15399.84 | 7470 | 48
1767.2 | 7471 | 10
889.24 | 7472 | 4
1805 | 7473 | 6
2694.48 | 7477 | 24
2133.28 | 7478 | 8
32.86 | 7479 | 1
1660 | 7480 | 2
26214.96 | 7481 | 12
270819.3 | 7485 | 274
1773.75 | 7487 | 1
82392.24 | 7495 | 60
3799.25 | 7496 | 3
276479.35 | 7497 | 36
1325 | 7498 | 1
3600 | 7499 | 48
55200 | 7500 | 15
23291.7 | 7501 | 12
1000 | 7503 | 1
10320.96 | 7504 | 48
71100 | 7505 | 18
11225.04 | 7506 | 12
5099.53 | 7510 | 2
12216.24 | 7520 | 48
313.75 | 7524 | 1
17250.06 | 7525 | 18
10333.32 | 7526 | 4
3000 | 7527 | 3
30833.35 | 7544 | 9
475.02 | 7545 | 6
45200.04 | 7546 | 12
34157.24000000001 | 7549 | 22
1565.1 | 7556 | 94
4200 | 7559 | 4
13999.98 | 7560 | 6
103081.25 | 7561 | 635
11107.74 | 7562 | 21
8916.66 | 7564 | 14
500 | 7565 | 1
12250.05 | 7566 | 15
5000.01 | 7567 | 3
200 | 7568 | 4
46398.3 | 7569 | 28
37308.48 | 7570 | 48
24370 | 7571 | 57
113100 | 7572 | 240
143005.2 | 7573 | 39
9460.02 | 7591 | 6
2208.33 | 7592 | 1
2232 | 7604 | 4
16200 | 7605 | 12
27943.44 | 7606 | 26
42000 | 7607 | 12
21873.33 | 7608 | 4
42000 | 7609 | 6
14642.48 | 7610 | 8
2068.56 | 7611 | 24
8707.5 | 7612 | 3
7036.320000000001 | 7619 | 50
3941.66 | 7622 | 2
2375217.3 | 7637 | 18086
13000 | 7638 | 1
27500.04 | 7639 | 12
1816.68 | 7640 | 6
5670 | 7641 | 9
8500 | 7642 | 16
3285.72 | 7643 | 2
13800 | 7644 | 6
7360.08 | 7645 | 24
28217 | 7646 | 12
7808.49 | 7647 | 39
17500 | 7648 | 5
650 | 7649 | 1
650 | 7650 | 1
46589.22 | 7651 | 141
131908.28 | 7667 | 1018
11200 | 7681 | 8
20055 | 7682 | 24
22001 | 7683 | 17
89400 | 7684 | 183
19049.99 | 7685 | 4
32400 | 7686 | 24
13500 | 7687 | 3
19499.99 | 7688 | 4
6250 | 7694 | 5
21200 | 7699 | 6
55963.38 | 7700 | 23
8223.75 | 7701 | 9
650 | 7704 | 1
13000 | 7710 | 1
1265 | 7711 | 1
1232.67 | 7712 | 1
26499.96 | 7713 | 12
1767.2 | 7727 | 10
5130 | 7737 | 24
26499.96 | 7741 | 12
2687.5 | 7744 | 1
2800 | 7745 | 1
3800 | 7746 | 2
32000 | 7747 | 1
27626.96 | 7756 | 88
159556.68 | 7757 | 18
13958.12 | 7762 | 4
75140 | 7763 | 26
44.06 | 7764 | 1
7321.24 | 7765 | 4
4400 | 7766 | 8
2200 | 7767 | 4