Spreadsheet: 850189d1700571929-help-with-index-match-or-whatever-can-work-please-excelforum-sample-1-aligw
Sheet: Sending Coy Data

 | Ref Number | Qty | Value |  | Receiving Coy Ref Number |  | AliGW
 | 2747 | 6 | 19999.98 |  | 7314
 | 2748 | 6 | 16800 |  | 7316
 | 2749 | 60 | 17415 |  | 7464
 | 2750 | 12 | 18705 |  | 7653
 | 2751 | 12 | 9450 |  | 9319
 | 3000 | 138 | 30474.54 |  | 7309
 | 3001 | 11 | 4583.37 |  | 7299
 | 3002 | 6 | 2820 |  | 7300
 | 3003 | 2 | 4401.76 |  | 7301
 | 4546 | 1289 | 468779.17 |  | 7293
 | 4549 | 6 | 2250
 | 4550 | 6 | 16800
 | 4551 | 4 | 8500
 | 4552 | 24 | 26470.32
 | 2752 | 9 | 468.72
 | 3005 | 10 | 2208.3
 | 3007 | 65 | 117022.75
 | 4556 | 106 | 137363.14
 | 4557 | 168 | 37099.44
 | 4558 | 1 | 7041.67
 | 2753 | 93 | 20537.19
 | 2757 | 6 | 16354.98
 | 2758 | 24 | 6600
 | 2759 | 6 | 9000
 | 2760 | 12 | 36999.96
 | 2761 | 6 | 1230
 | 2762 | 6 | 7999.98
 | 2763 | 12 | 2580.24
 | 3010 | 1 | 1271.25
 | 3011 | 28 | 12395.74
 | 3015 | 642 | 90441.94
 | 3016 | 1 | 895.71
 | 3017 | 14 | 9100
 | 3018 | 10 | 1301.3
 | 3023 | 142 | 42895.36
 | 3025 | 30 | 6624.9
 | 3026 | 1 | 388.32
 | 3027 | 121 | 27570.55
 | 3028 | 33 | 30309.54
 | 4559 | 76 | 80135.2
 | 4561 | 10 | 22000
 | 4564 | 7 | 42000
 | 4565 | 1 | 302.08
 | 4567 | 14 | 10125
 | 2764 | 9 | 49500
 | 2767 | 12 | 6000
 | 2768 | 8 | 27499.98
 | 2769 | 6 | 3600
 | 2773 | 2 | 1040
 | 2774 | 2 | 726
 | 2775 | 6 | 9000
 | 2776 | 2 | 4700
 | 3030 | 1 | 5500
 | 3038 | 1 | 679
 | 3039 | 1 | 142.42
 | 3040 | 12 | 12000
 | 4571 | 4 | 7200
 | 4572 | 1 | 3225
 | 4573 | 12 | 3750
 | 4574 | 1 | 3150
 | 4577 | 9 | 21469.42
 | 4578 | 1 | 7500
 | 4579 | 5 | 8333.35
 | 4580 | 1 | 1500
 | 4581 | 12 | 7250.04
 | 3046 | 4 | 15500
 | 3047 | 720 | 56330.4
 | 3048 | 40 | 6555.6
 | 4585 | 6 | 5374.98
 | 4588 | 1 | 1666.67
 | 2784 | 53 | 14575
 | 2786 | 15 | 67666.69
 | 3053 | 696 | 29096.4
 | 3054 | 100 | 9000
 | 3055 | 15 | 7575
 | 3056 | 4 | 5266.68
 | 4591 | 16 | 18960
 | 4592 | 221 | 25784.07
 | 4593 | 6 | 13750.02
 | 4594 | 19 | 51251.21000000001
 | 4595 | 4 | 10000
 | 4596 | 41 | 3165.36
 | 2788 | 5 | 5000
 | 2789 | 4 | 466.68
 | 2790 | 12 | 31000.02
 | 2791 | 6 | 16800
 | 2792 | 48 | 13932
 | 2793 | 12 | 2967
 | 2794 | 6 | 19999.98
 | 2795 | 12 | 2460
 | 2796 | 8 | 1139.36
 | 4602 | 42 | 11550
 | 4607 | 120 | 38400
 | 4611 | 6 | 9460.02
 | 4612 | 40 | 95100
 | 4613 | 22 | 24712.55
 | 4614 | 84 | 27862.8
 | 4615 | 9 | 3323.07
 | 4616 | 35 | 45986.15
 | 4617 | 4 | 10000
 | 4618 | 10 | 17468.8
 | 4619 | 64 | 13761.28
 | 2797 | 7 | 16659.8
 | 2798 | 6 | 9000
 | 2799 | 4 | 49029.6
 | 2800 | 19 | 19999.97
 | 2801 | 11 | 6021.25
 | 2802 | 12 | 65604.72
 | 2803 | 88 | 22026.08
 | 4624 | 26 | 62648.62
 | 4625 | 34 | 12460.41
 | 2805 | 2 | 4593.26
 | 3064 | 56 | 7036
 | 3065 | 120 | 27256.8
 | 3069 | 12 | 28899.96
 | 3070 | 16 | 26961
 | 4628 | 16 | 25689.97
 | 4630 | 16 | 23220
 | 2807 | 12 | 3483
 | 2809 | 1 | 1475
 | 2810 | 9 | 49500
 | 2811 | 15 | 4134.45
 | 3077 | 36 | 32595.01
 | 3078 | 48 | 3600
 | 3079 | 24 | 3300
 | 3080 | 24 | 6600
 | 3081 | 42 | 131425.68
 | 3082 | 6 | 15000
 | 4638 | 24 | 64810.00999999999
 | 4639 | 8 | 2953.84
 | 4640 | 25 | 7656.25
 | 4641 | 22 | 12112.14
 | 4642 | 12 | 9450
 | 4644 | 48 | 12216.24
 | 2812 | 5 | 11000
 | 3087 | 240 | 43200
 | 3088 | 12 | 2280
 | 3092 | 18 | 38557.98
 | 4652 | 10 | 34091.2
 | 4655 | 12 | 27500.04
 | 4656 | 12 | 13331.64
 | 4657 | 6 | 19750.62
 | 2816 | 1 | 209.04
 | 2817 | 15 | 67666.69
 | 2818 | 24 | 5299.92
 | 2819 | 12 | 16500
 | 2820 | 72 | 2720.16
 | 2821 | 12 | 90300
 | 2822 | 6 | 1500
 | 2823 | 6 | 14333.34
 | 2824 | 6 | 4150.02
 | 2825 | 1 | 1702.08
 | 3099 | 13 | 18416.71
 | 4663 | 18 | 41942.75
 | 4664 | 1 | 1166.67
 | 4665 | 1 | 108.33
 | 2826 | 24 | 21285
 | 2827 | 12 | 39501.24
 | 2829 | 3 | 681.42
 | 2830 | 34 | 26349.92
 | 3103 | 1 | 500
 | 3106 | 190 | 23249.4
 | 3107 | 163 | 131994.39
 | 3108 | 4 | 5672.79
 | 4669 | 971 | 220552.94
 | 4673 | 48 | 15399.84
 | 4674 | 10 | 1767.2
 | 4675 | 4 | 889.24
 | 4676 | 6 | 1805
 | 2833 | 1 | 299.68
 | 2834 | 2 | 140
 | 2835 | 20 | 16320
 | 2836 | 10 | 14070
 | 2837 | 3 | 9999.99
 | 2838 | 60 | 17415
 | 2839 | 160 | 197985.71
 | 3115 | 3 | 4074.99
 | 3116 | 84 | 19874.64
 | 3120 | 120 | 6249.6
 | 3121 | 2 | 2276.12
 | 3122 | 4 | 1400.64
 | 4682 | 12 | 35199.96
 | 4684 | 274 | 270819.3
 | 4687 | 12 | 26214.96
 | 4688 | 2 | 1660
 | 4689 | 1 | 32.86
 | 4690 | 8 | 2133.28
 | 4691 | 24 | 2694.48
 | 4694 | 1 | 1325
 | 4695 | 48 | 3600
 | 4696 | 15 | 55200
 | 4697 | 12 | 23291.7
 | 4698 | 48 | 10320.96
 | 4699 | 18 | 71100
 | 4700 | 12 | 11225.04
 | 4701 | 60 | 82392.24
 | 4702 | 36 | 276479.35
 | 4703 | 1 | 1000
 | 4704 | 3 | 3799.25
 | 2842 | 10 | 8000
 | 2843 | 24 | 906.72
 | 2844 | 6 | 9333.36
 | 2845 | 12 | 2919.96
 | 2846 | 4 | 8040
 | 2847 | 24 | 5451.36
 | 2848 | 12 | 24600
 | 2849 | 24 | 5299.92
 | 2850 | 24 | 4249.92
 | 3130 | 96 | 21199.68
 | 3131 | 2 | 569.58
 | 3132 | 24 | 12861.44
 | 3133 | 12 | 36056.04
 | 3134 | 36 | 5900.04
 | 3135 | 240 | 49249.2
 | 3137 | 12 | 16200
 | 3138 | 12 | 8600.04
 | 4707 | 1 | 1773.75
 | 4708 | 2 | 5099.53
 | 4710 | 9 | 30833.35
 | 4711 | 18 | 17250.06
 | 4712 | 4 | 10333.32
 | 4713 | 3 | 3000
 | 2851 | 3 | 291.9
 | 2852 | 12 | 31000.02
 | 2853 | 12 | 6000
 | 2854 | 6 | 16800
 | 2855 | 12 | 18705
 | 2856 | 12 | 4532
 | 2857 | 12 | 11225.04
 | 2858 | 16 | 8901
 | 2859 | 12 | 3300
 | 2860 | 6 | 45150
 | 2861 | 3 | 4300.02
 | 2862 | 12 | 2460
 | 2863 | 6 | 19999.98
 | 2864 | 24 | 2149.92
 | 2866 | 104 | 7700
 | 3144 | 12 | 2258.37
 | 3145 | 4 | 240
 | 3146 | 1 | 1200
 | 4718 | 4 | 4200
 | 4719 | 3 | 8707.5
 | 4722 | 1 | 313.75
 | 2868 | 23 | 23488.75
 | 3151 | 84 | 17080.2
 | 4728 | 12 | 45200.04
 | 4729 | 6 | 475.02
 | 2869 | 9 | 6337.53
 | 2870 | 11 | 4950
 | 2871 | 60 | 17415
 | 2872 | 1 | 2600
 | 2873 | 12 | 26499.96
 | 2874 | 10 | 33500
 | 2875 | 12 | 3849.96
 | 2876 | 50 | 4500
 | 2877 | 9 | 5670
 | 2878 | 3 | 4269.309999999999
 | 3153 | 6 | 4116
 | 4733 | 22 | 34157.24000000001
 | 4734 | 94 | 1565.1
 | 4735 | 48 | 37308.48
 | 4736 | 28 | 46398.3
 | 4737 | 4 | 200
 | 4738 | 15 | 12250.05
 | 4739 | 3 | 5000.01
 | 4740 | 1 | 500
 | 4741 | 14 | 8916.66
 | 4742 | 21 | 11107.74
 | 2879 | 15 | 31085.64
 | 3160 | 36 | 5900.04
 | 3161 | 6 | 11520
 | 3162 | 12 | 3965.04
 | 4747 | 6 | 13999.98
 | 4748 | 635 | 103081.25
 | 4750 | 39 | 143005.2
 | 4751 | 240 | 113100
 | 4752 | 57 | 24370
 | 2880 | 3 | 3870
 | 2881 | 12 | 6000
 | 2882 | 2 | 8600
 | 2883 | 26 | 15101.96
 | 2884 | 12 | 31000.02
 | 2885 | 6 | 19999.98
 | 2886 | 12 | 3300
 | 2887 | 10 | 8000
 | 2888 | 2 | 3800
 | 2889 | 12 | 33600
 | 2890 | 6 | 9000
 | 2891 | 12 | 45600
 | 2893 | 17 | 3842.68
 | 3170 | 1 | 145.12
 | 4756 | 1 | 2208.33
 | 4757 | 6 | 9460.02
 | 2894 | 4 | 17200
 | 2895 | 12 | 2460
 | 2896 | 24 | 4320
 | 2897 | 12 | 26499.96
 | 2898 | 24 | 906.72
 | 2899 | 6 | 19999.98
 | 3176 | 7 | 10000.02
 | 3177 | 132 | 28260.36
 | 3178 | 8 | 5606.48
 | 3179 | 1 | 3225
 | 3180 | 12 | 14000.04
 | 3181 | 18 | 30637.56
 | 3182 | 8 | 5606.48
 | 3183 | 24 | 2280
 | 3184 | 2 | 4750
 | 3185 | 24 | 5130
 | 4762 | 4 | 2232
 | 4763 | 12 | 16200
 | 4764 | 26 | 27943.44
 | 4765 | 12 | 42000
 | 4766 | 4 | 21873.33
 | 4767 | 6 | 42000
 | 4768 | 8 | 14642.48
 | 4769 | 24 | 2068.56
 | 2900 | 2 | 10000
 | 2901 | 24 | 26877
 | 4771 | 2 | 3941.66
 | 4772 | 2 | 3285.72
 | 4775 | 50 | 7036.320000000001
 | 2902 | 20 | 32564.5
 | 2903 | 36 | 1360.08
 | 2904 | 12 | 1250.04
 | 2905 | 7 | 18666.67
 | 2906 | 12 | 9792
 | 2907 | 10 | 3400
 | 2908 | 48 | 3600
 | 2909 | 2 | 8400
 | 2910 | 12 | 1074.96
 | 2911 | 5 | 1750
 | 2912 | 26 | 37500.02
 | 2913 | 43 | 28180.66
 | 2914 | 3 | 225
 | 4779 | 141 | 46589.22
 | 4780 | 18086 | 2375217.3
 | 4781 | 5 | 17500
 | 4782 | 1 | 650
 | 4783 | 1 | 650
 | 4784 | 24 | 7360.08
 | 4785 | 39 | 7808.49
 | 4786 | 12 | 28217
 | 4787 | 6 | 13800
 | 4788 | 16 | 8500
 | 4789 | 9 | 5670
 | 4790 | 6 | 1816.68
 | 4791 | 12 | 27500.04
 | 4792 | 1 | 13000
 | 2915 | 24 | 3600
 | 2916 | 12 | 18705
 | 2917 | 6 | 9000
 | 2918 | 12 | 9450
 | 2919 | 36 | 9172.44
 | 2920 | 6 | 27000
 | 2921 | 24 | 116799.96
 | 2922 | 12 | 2258.37
 | 2923 | 11 | 17233.35
 | 2924 | 3 | 2100
 | 2925 | 3 | 7500
 | 2926 | 5 | 21500
 | 2927 | 6 | 1230
 | 2928 | 18 | 47800.02
 | 2929 | 12 | 24999.96
 | 3193 | 72 | 198000
 | 3194 | 48 | 20610
 | 3195 | 240 | 43200
 | 3196 | 24 | 8500.08
 | 3197 | 12 | 199.8
 | 4797 | 1018 | 131908.28
 | 2932 | 10 | 35151.76
 | 2934 | 24 | 6114.96
 | 3201 | 36 | 5900.04
 | 3202 | 10 | 10833.3
 | 3203 | 10 | 3400
 | 3204 | 9 | 1198.83
 | 3209 | 12 | 8300.04
 | 3210 | 6 | 5400
 | 3211 | 6 | 1816.68
 | 3212 | 20 | 5232.8
 | 3213 | 12 | 14000.04
 | 3214 | 6 | 16200
 | 3216 | 30 | 20832.9
 | 3218 | 147 | 231388.45
 | 4801 | 23 | 55963.38
 | 4802 | 1 | 650
 | 4803 | 8 | 11200
 | 4804 | 24 | 20055
 | 4805 | 17 | 22001
 | 4806 | 183 | 89400
 | 4807 | 4 | 19049.99
 | 4808 | 24 | 32400
 | 4809 | 3 | 13500
 | 4810 | 4 | 19499.99
 | 2935 | 54 | 30511.5
 | 2936 | 42 | 25493.16
 | 2937 | 4 | 520
 | 2938 | 12 | 24999.96
 | 2939 | 12 | 2457
 | 2940 | 17 | 70771.84
 | 3222 | 30 | 23400
 | 3223 | 1 | 4206.45
 | 3232 | 24 | 399.6
 | 3233 | 192 | 34560
 | 3234 | 24 | 33600
 | 3235 | 10 | 12777.8
 | 3236 | 2 | 2555.56
 | 4813 | 9 | 8223.75
 | 4814 | 5 | 6250
 | 4815 | 6 | 21200
 | 4819 | 12 | 26499.96
 | 4820 | 1 | 1232.67
 | 4821 | 1 | 1265
 | 4822 | 1 | 13000
 | 2941 | 3 | 4350
 | 2942 | 5 | 2500
 | 3244 | 26 | 95300.06
 | 3245 | 24 | 4750.02
 | 3246 | 54 | 26430
 | 3247 | 179 | 269040.92
 | 3249 | 19 | 22800
 | 3250 | 6 | 1083.36
 | 3252 | 26 | 50399.89
 | 4823 | 1 | 2687.5
 | 4827 | 24 | 5130
 | 2943 | 6 | 21000
 | 3255 | 6 | 10981.86
 | 3256 | 120 | 21600
 | 3257 | 12 | 9450
 | 3258 | 1 | 783.33
 | 3259 | 24 | 399.6
 | 3260 | 24 | 33600
 | 4831 | 18 | 159556.68
 | 4832 | 10 | 1767.2
 | 2944 | 120 | 21600
 | 2945 | 1 | 4500
 | 2946 | 6 | 45150
 | 2947 | 6 | 1650
 | 2948 | 30 | 16920
 | 2949 | 10 | 1104.2
 | 2950 | 24 | 29142
 | 2951 | 10 | 3400
 | 2952 | 6 | 14870.82
 | 2953 | 11 | 25621.84
 | 2954 | 12 | 24999.96
 | 4835 | 12 | 26499.96
 | 4836 | 1 | 2800
 | 4837 | 2 | 3800
 | 4838 | 1 | 32000
 | 2955 | 11 | 17233.35
 | 2956 | 122 | 21980
 | 2957 | 6 | 19000.02
 | 2958 | 3 | 7500
 | 2959 | 4 | 1670
 | 2960 | 2 | 3818.5
 | 2961 | 1 | 645
 | 2962 | 6 | 9000
 | 2963 | 14 | 9424.97
 | 2964 | 21 | 33456.75
 | 3267 | 5 | 237.05
 | 3268 | 4 | 18275
 | 3270 | 6 | 4166.58
 | 3272 | 120 | 21600
 | 4843 | 88 | 27626.96
 | 4844 | 4 | 7321.24
 | 4845 | 8 | 4400
 | 4846 | 1 | 44.06
 | 4847 | 4 | 13958.12
 | 4848 | 26 | 75140
 | 4849 | 4 | 2200
 | 4850 | 32 | 3399.96
 | 4851 | 4 | 2200