Spreadsheet: 746857d1631077281-look-up-name-to-calculate-its-corresponding-front-value-averageif-index-and-match-file
Sheet: Sheet

Variant | Sales | Average Sales
Oranges | 7500
Oranges | 6750
Oranges | 6860
Oranges | 6900
Oranges | 6950
Oranges | 6800
Oranges | 7260
Oranges | 6950
Oranges | 6950
Oranges | 6850
Oranges | 7110
Oranges | 6950
Oranges | 6950
Oranges | 6696
Oranges | 6930
Oranges | 6950
Oranges | 6800
Oranges | 6950
Oranges | 6950
Oranges | 6836
Oranges | 6800
Oranges | 6750
Oranges | 6600
Oranges | 6650
Apples | 8750
Apples | 9010
Apples | 9281
Apples | 8500
Apples | 8862
Apples | 9000
Apples | 9300
Apples | 8890
Apples | 9000
Apples | 9130
Apples | 9000
Apples | 9260
Apples | 8510
Apples | 9260
Apples | 9260
Apples | 9000
Apples | 8900
Apples | 8815
Apples | 9260
Apples | 9260
Apples | 8731
Apples | 8760
Apples | 8760
Apples | 8860
Apples | 8760
Apples | 9260
Strawberries | 9892
Strawberries | 9895
Strawberries | 9957
Strawberries | 9900
Strawberries | 9657
Strawberries | 9586
Strawberries | 9357
Strawberries | 10015
Strawberries | 9857
Strawberries | 10165
Strawberries | 9767
Strawberries | 9857
Strawberries | 9800
Strawberries | 9857
Strawberries | 9650
Strawberries | 9537
Strawberries | 10000
Strawberries | 9887
Strawberries | 9760
Strawberries | 9757
Strawberries | 9887
Strawberries | 9981
Strawberries | 10152
Strawberries | 9887
Strawberries | 9887
Strawberries | 9957
Strawberries | 10257
Strawberries | 10000
Strawberries | 10300
Strawberries | 10257
Strawberries | 10257
Strawberries | 10257
Strawberries | 10257
Strawberries | 9857
Strawberries | 9772
Strawberries | 9628
Strawberries | 9357
Strawberries | 9857
Strawberries | 9607
Strawberries | 9887
Strawberries | 9757
Strawberries | 9607
Strawberries | 9769
Strawberries | 9757
Strawberries | 9557
Strawberries | 9887
Cakes | 11970
Cakes | 11920
Cakes | 12020
Cakes | 12105
Cakes | 11420
Cakes | 12555
Cakes | 12225
Breads | 12970
Breads | 12970
Coffee | 17672
Coffee | 16673
Coffee | 17302
Coffee | 17172
Coffee | 16826
Coffee | 16572
Coffee | 16350
Coffee | 16350
Coffee | 16350
Coffee | 16350
Coffee | 16350
Coffee | 16350
Coffee | 16655
Coffee | 16848
Coffee | 16477
Coffee | 16597
Coffee | 16350
Coffee | 17130
Coffee | 16350
Coffee | 16350
Coffee | 16350
Coffee | 16605
Coffee | 16847
Coffee | 16473
Coffee | 16752
Coffee | 16672
Coffee | 16922
Coffee | 17172
Coffee | 16672
Coffee | 16802
Coffee | 16425
Coffee | 16847
Coffee | 17672
Coffee | 17672
Coffee | 16672
Coffee | 16572
Coffee | 16672
Coffee | 16802
Coffee | 17122
Coffee | 16922
Coffee | 16447
Coffee | 17002
Coffee | 16672
Coffee | 16772
Stars | 19173
Stars | 20072
Stars | 19573
Stars | 19302
Stars | 19172
Stars | 19702
Stars | 19122
Stars | 19657
Stars | 20065
Stars | 17922
Stars | 18993
Stars | 19043
Stars | 19117
Stars | 19452
Stars | 19272
Stars | 19922
Stars | 18657
Stars | 19572
Stars | 19272
Stars | 19572
Stars | 19352
Stars | 19372
Stars | 19172
Stars | 20072
Stars | 19572
Stars | 19592
Stars | 19702
Stars | 19547
Stars | 19197
Stars | 18672
Stars | 23772
Stars | 19172
Stars | 18572
Stars | 19155
Stars | 19172
Stars | 20072
Stars | 19097
Stars | 19372
Stars | 17922
Stars | 19572
Stars | 19572
Stars | 19172
Stars | 19573
Stars | 19472
Stars | 19322
Stars | 19422
Stars | 18772
Stars | 19116
Stars | 19002
Stars | 19202
Stars | 19172
Stars | 19172
Stars | 19172
Stars | 18822
Mice | 8147
Mice | 8147
Mice | 6654
Mice | 7732
[NAME] | 9597
[NAME] | 9347
[NAME] | 9847
[NAME] | 8907
Dogs | 7347
Dogs | 7797
Dogs | 7640
Dogs | 6850
Dog | 7180
Dog | 7030
Dog | 6980
Dog | 7106
Dog | 7280
Dog | 7280
Dog | 7280
Dog | 7030
Dog | 7280
Dog | 7280
Dog | 7280
Dog | 7030
Dog | 7020
Dog | 7280
Dog | 7580
Dog | 7080
Dog | 7280
Dog | 6880
Dog | 6980
Cats | 7780
Cats | 8280
Cats | 8280
Cats | 7860
Cats | 8035
Cats | 8180
Cats | 8280
Lions | 6230
Lions | 6280
Lions | 8880
Lions | 8180
Comfy | 14115
Comfy | 14615
Comfy | 13565
Comfy | 13768
Comfy | 13765
Comfy | 13865
Comfy | 13765
Comfy | 13865
Comfy | 14185
Comfy | 12999
Comfy | 12999
Comfy | 13850
Comfy | 14065
Comfy | 13638
Comfy | 14086
Comfy | 14685
Comfy | 14685
Comfy | 13695
Comfy | 13623
Comfy | 13515
Comfy | 13865
Comfy | 13750
Comfy | 12999
Comfy | 12999
Comfy | 13265
Comfy | 14140
Comfy | 13585
Comfy | 12999
Comfy | 14255
Comfy | 14265
Comfy | 12999
Comfy | 12999
Comfy | 12999
Comfy | 13665
Comfy | 13765
Comfy | 12999
Comfy | 12999
Comfy | 13515
Comfy | 14185
Comfy | 14265
Comfy | 13765
Comfy | 14031
Comfy | 14085
Comfy | 13465
Comfy | 14265
Comfy | 13765
Comfy | 13765
Comfy | 12999
Comfy | 12999
Comfy | 13550
Comfy | 13515
Comfy | 13665
Comfy | 13555
Comfy | 13565
Comfy | 13665
Comfy | 13765
Comfy | 13565
Comfy | 12999
Comfy | 12999
Comfy | 12999
Comfy | 13545
Comfy | 13565
Comfy | 13600
Comfy | 14285
Comfy | 13630
Comfy | 13790
Comfy | 13615
Comfy | 13865
Comfy | 13765
Comfy | 12999
Comfy | 13515
Comfy | 12999
Comfy | 12999
Comfy | 12999
Comfy | 12999
Comfy | 13605
Clumsy | 14829
Clumsy | 15665
Clumsy | 16285
Clumsy | 15915
Clumsy | 15540
Clumsy | 15615
Clumsy | 15530
Clumsy | 16035
Clumsy | 15484
Clumsy | 16275
Clumsy | 16685
Clumsy | 15765
Clumsy | 15585
Clumsy | 15365
Clumsy | 14829
Clumsy | 14829
Clumsy | 16485
Clumsy | 14829
Clumsy | 14829
Clumsy | 14829
Clumsy | 14829
Clumsy | 16115
Clumsy | 15865
Clumsy | 15565
Clumsy | 15565
Clumsy | 15365
Clumsy | 15365
Clumsy | 14829
Clumsy | 15249
Clumsy | 15785
Clumsy | 14829
End | 9800
End | 10280
End | 10130
End | 10000
End | 9980
Finish | 11501
Finish | 11464
Finish | 11456
Finish | 11180
Finish | 11736
Finish | 11765
Finish | 11630
Death | 12380
Death | 11880