Spreadsheet: 221588d1363618035-duplicate-values-returned-using-index-match-lookup-with-small-sum-index-match
Sheet: Sheet1

 | 00311 | 15200 | 00311 | Top Ten | Amount
 | 00405 | 958480 | 00405 |  |  |  |  | 1
 | 00415 | 862621 | 00415 |  |  |  |  | 2
 | 00706 | 12350 | 00706 |  |  |  |  | 3
 | 02004 | 56704 | 02004 |  |  |  |  | 4
 | 02007 | 68096 | 02007 |  |  |  |  | 5
 | 02012 | 26200 | 02012 |  |  |  |  | 6
 | 07220 | 12198 | 07220 |  |  |  |  | 7
 | 20216 | 12000 | 20216 |  |  |  |  | 8
 | 30001 | 150 | 30001 |  |  |  |  | 9
 | 30002 | 11400 | 30002 |  |  |  |  | 10
 | 30003 | 11400 | 30003
 | 30004 | 15200 | 30004
 | 30005 | 7600 | 30005
 | 30006 | 21850 | 30006 | Bottom Ten | Amount
 | 30007 | 11400 | 30007 |  |  |  |  | 10
 | 30008 | 19000 | 30008 |  |  |  |  | 9
 | 30009 | 15200 | 30009 |  |  | 41116 |  | 8
 | 30010 | 15200 | 30010 |  |  | 40810BP |  | 7
 | 30011 | 27550 | 30011 |  |  | 40811BP |  | 6
 | 40080 | 45152 | 40080 |  |  |  |  | 5
 | 40085 | 26428 | 40085 |  |  |  |  | 4
 | 40622 | 2914615 | 40622 |  |  |  |  | 3
 | 40629 | 26080 | 40629 |  |  |  |  | 2
 | 40810 | 22400 | 40810 |  |  |  |  | 1
 | 40811 | 22400 | 40811
 | 40835 | 806466 | 40835 |  | SMALL(C$5:C$132,$I22)
 | 40836 | 279242 | 40836 | INDEX($B$5:$B$132,MATCH($F22,$C$5:$C$132,0))
 | 40837 | 345887 | 40837
 | 40838 | 85728 | 40838
 | 40839 | 440952 | 40839
 | 40840 | 1877438 | 40840
 | 40841 | 736440 | 40841
 | 40842 | 910504 | 40842
 | 40843 | 717250 | 40843
 | 40844 | 4500 | 40844
 | 40847 | 9310 | 40847
 | 40848 | 3800 | 40848
 | 40984 | 107730 | 40984
 | 40992 | 4614 | 40992
 | 40999 | 6000 | 40999
 | 41000 | 36619 | 41000
 | 41005 | 19000 | 41005
 | 41008 | 53200 | 41008
 | 41011 | 15200 | 41011
 | 41017 | 53048 | 41017
 | 41018 | 10298 | 41018
 | 41022 | 1965930 | 41022
 | 41023 | 988286.8 | 41023
 | 41025 | 4712 | 41025
 | 41043 | 4142 | 41043
 | 41049 | 213028 | 41049
 | 41050 | 7600 | 41050
 | 41059 | 26600 | 41059
 | 41060 | 3002 | 41060
 | 41061 | 49680 | 41061
 | 41062 | 19272 | 41062
 | 41064 | 32000 | 41064
 | 41065 | 121248 | 41065
 | 41066 | 116166 | 41066
 | 41068 | 151762 | 41068
 | 41070 | 86164 | 41070
 | 41071 | 79436 | 41071
 | 41072 | 190178.64 | 41072
 | 41073 | 168079.36 | 41073
 | 41076 | 15074 | 41076
 | 41077 | 25898 | 41077
 | 41089 | 6000 | 41089
 | 41090 | 4320 | 41090
 | 41091 | 6760 | 41091
 | 41092 | 4066 | 41092
 | 41093 | 3500 | 41093
 | 41094 | 3379 | 41094
 | 41095 | 6000 | 41095
 | 41096 | 2500 | 41096
 | 41102 | 25420 | 41102
 | 41106 | 30100 | 41106
 | 41107 | 11020 | 41107
 | 41108 | 120840 | 41108
 | 41109 | 121600 | 41109
 | 41110 | 61104 | 41110
 | 41111 | 170088 | 41111
 | 41112 | 282188 | 41112
 | 41113 | 79192 | 41113
 | 41116 | 3200 | 41116
 | 41335 | 8880 | 41335
 | 41336 | 9310 | 41336
 | 41500 | 16400 | 41500
 | 41503 | 7600 | 41503
 | 41550 | 16400 | 41550
 | 41553 | 7600 | 41553
 | 41700 | 16800 | 41700
 | 41703 | 7600 | 41703
 | 41800 | 29200 | 41800
 | 41803 | 7600 | 41803
 | 60432 | 1181657 | 60432
 | 60480 | 793551 | 60480
 | 60481 | 737176 | 60481
 | 99987 | 5548 | 99987
 | 631001 | 167200 | 631001
 | 631005 | 189924 | 631005
 | 631009 | 81400 | 631009
 | 631011 | 57000 | 631011
 | 631015 | 49400 | 631015
 | 631016 | 72200 | 631016
 | 631017 | 19000 | 631017
 | 631021 | 3800 | 631021
 | 631022 | 110276 | 631022
 | 07220B | 3800 | 07220B
 | 40622A | 217930 | 40622A
 | 40622B | 1973726 | 40622B
 | 40622BP | 1897 | 40622BP
 | 40622C | 19000 | 40622C
 | 40622N | 1903 | 40622N
 | 40810BP | 3200 | 40810BP
 | 40811BP | 3200 | 40811BP
 | 40835B | 597034 | 40835B
 | 40835C | 19000 | 40835C
 | 40840B | 11400 | 40840B
 | 40840C | 7600 | 40840C
 | 41000C | 5095 | 41000C
 | 41066N | 136724 | 41066N
 | 41070BP | 64800 | 41070BP
 | 41071BP | 3600 | 41071BP
 | 41072BP | 82800 | 41072BP
 | 41073BP | 3600 | 41073BP
 | 41336C | 7600 | 41336C
 | RD 0001 | 3800 | RD 0001