Spreadsheet: 123324d1317570708-how-to-use-row-data-to-perform-a-function-against-all-other-rows-matching-example
Sheet: Sheet1

Range | VOL(m) | Gp | V1 | V2 | V3 | Gain | Match |  |  |  | 25 | 16 | 3
0.04 | 4.1 | A1 | 25 | 16 | 3 | 35 |  |  |  |  | These are the values from d2, e2, and f2
0.03 | 6.5 | A1 | 41 | 29 | 1.1 | 38
0.04 | 5.2 | A1 | 75 | 54 | 17 | 40 |  |  |  |  | When I want to "match" a new data set, I have to change the values in l1, m1, and o1
0.01 | 101 | A1 | 275 | 86 | 10 | 47
0.05 | 3.6 | A1 | 81 | 124 | 30 | 48 |  |  |  |  | ideally, each row would match to the other rows and spit out the values in coll. G for the matching row
0.004 | 0.76 | A1 | 71 | 18 | 1.1 | 55
0.02 | 15.2 | A1 | 140 | 108 | 15 | 58
0.1 | 0.85 | A1 | 25 | 25 | 5 | 65
0.03 | 5.8 | A1 | 49 | 62 | 1.1 | 66
0.01 | 10.2 | A1 | 50 | 38 | 1.1 | 69
0.03 | 33.9 | A1 | 88 | 138 | 13 | 87
0.5 | 2.6 | A1 | 10 | 13 | -2 | 89
0.006 | 6 | A1 | 56 | 63 | 62 | 114
0.04 | 1.9 | A1 | 22 | 61 | 0.2 | 130
0.03 | 2.1 | A1 | 22 | 13 | 6 | 150
0.006 | 1.7 | A1 | 50 | 30 | 14 | 152
0.006 | 22.8 | A1 | 67 | -38 | -8 | 154
0.3 | 2.1 | A1 | 73 | 29 | 16 | 167
0.07 | 47.1 | A1 | 105 | 89 | 3 | 167
0.02 | 1.8 | A1 | 50 | 25 | 6 | 208
0.007 | 15.5 | A1 | 70 | 97 | 6 | 241
0.02 | 9.6 | A1 | 43 | 37 | 4 | 285
0.06 | 58.6 | A1 | 87 | 40 | 45 | 288
0.02 | 4.3 | A1 | 26 | 48 | 5 | 307
0.01 | 9.7 | A1 | 61 | 29 | -3 | 360
0.005 | 4.7 | A1 | 23 | 17 | 5 | 400
0.004 | 17.7 | A1 | 61 | 114 | 8 | 408
0.07 | 3.2 | A1 | 23 | 37 | 3 | 472
0.002 | 0.94 | A1 | 1.1 | -7 | -8 | 650
0.01 | 35 | A1 | 82 | 20 | 1.1 | loss
0.02 | 0.6 | A1 | 89 | -13 | 4 | loss
0.05 | 3.1 | A1 | 44 | 22 | 8 | loss
0.01 | 17.7 | A1 | 380 | 358 | 36 | loss
0.02 | 46.4 | A1 | 322 | 650 | 50 | loss
0.07 | 95 | A1 | 300 | 25 | 59 | loss
0.01 | 8.4 | A1 | 86 | 33 | 5 | loss
0.01 | 2.4 | A1 | 13 | 0.7 | 0.8 | loss
0.01 | 3 | A1 | 15 | 0 | 6 | loss
0.007 | 7.6 | A1 | 32 | 27 | 11 | loss
0.2 | 0.85 | A1 | 115 | 118 | 36 | loss
1 | 3.7 | A1 | 12 | 16 | 1 | loss
0.1 | 18.5 | A1 | 19 | 18 | 12 | loss
1.6 | 5.4 | A1 | 28 | 39 | 10 | loss
0.01 | 9.2 | A1 | 195 | 124 | 1.1 | loss/285
0.02 | 5.2 | A2 | 42 | 27 | 14 | 24
0.05 | 12 | A2 | 170 | 1087 | 64 | 31
0.6 | 3.5 | A2 | 17 | -5 | 2 | 38
0.05 | 12.3 | A2 | 37 | 20 | 10 | 44
0.1 | 19 | A2 | 120 | 260 | 27 | 77
0.03 | 4 | A2 | 18 | 25 | 17 | 110
0.02 | 15.9 | A2 | 98 | 66 | 13 | 128
0.05 | 19 | A2 | 38 | 32 | 16 | 233
0.02 | 8.5 | A2 | 195 | 778 | 3 | 260
0.02 | 7.3 | A2 | 110 | 700 | 33 | 350
0.04 | 24.7 | A2 | 286 | 390 | -28 | loss
0.03 | 3.5 | A2 | 90 | 50 | 24 | loss
0.03 | 10.6 | A2 | 58 | 40 | 33 | loss
0.04 | 11.8 | A2 | 160 | 88 | 13 | loss
0.03 | 1.5 | A2 | 5 | 3 | -1 | loss
0.06 | 17.2 | A2 | 36 | 34 | 2 | loss
0.01 | 11.6 | A2 | 63 | -17 | -17 | loss
0.02 | 17.3 | A2 | 45 | 26 | 14 | loss
0.07 | 29 | A2 | 95 | 11 | 18 | loss
0.08 | 20.1 | A2 | 52 | 39 | 26 | loss
0.01 | 17.8 | A2 | 26 | 30 | -41 | loss
0.04 | 43.1 | A2 | 345 | 300 | 62 | loss
0.01 | 1.6 | A2 | 16 | 19 | 3 | loss
0.01 | 4.9 | A2 | 52 | 8 | 10 | loss
0.01 | 2.2 | A2 | 29 | 17 | 5 | loss
0.01 | 2.8 | A2 | 35 | 24 | 13 | loss
0.01 | 5.1 | A2 | 31 | 13 | 14 | loss
0.03 | 16.9 | A2 | 30 | 26 | 13 | loss
0.006 | 7.7 | A2 | 20 | 16 | 6 | loss
0.03 | 100.5 | A2 | 27 | -30 | 15 | loss
0.1 | 1.3 | A2 | 77 | 25 | 1.1 | loss
1.2 | 19.5 | A2 | 51 | 13 | 23 | loss
0.1 | 23.5 | A2 | 22 | 19 | 3 | loss
0.07 | 1.6 | A2 | 78 | 90 | 12 | loss*130
0.005 | 3.6 | A3 | 41 | 33 | 3 | loss
0.5 | 1 | A4 | 60 | 59 | 22 | 27
0.06 | 4.5 | A4 | 83 | 81 | 16 | 27
0.05 | 25 | A4 | 39 | 77 | 4 | 29
0.04 | 5.2 | A4 | 30 | 26 | 11 | 31
0.04 | 23.1 | A4 | 110 | 62 | 41 | 32
0.01 | 2.9 | A4 | 35 | 54 | 6 | 33
0.05 | 19 | A4 | 56 | 79 | 5 | 34
0.03 | 73 | A4 | 285 | 240 | 17 | 35
7.6 | 14.6 | A4 | 102 | 224 | 36 | 43
0.01 | 4.3 | A4 | 110 | 66 | 44 | 50
0.4 | 0.8 | A4 | 13 | 24 | 5 | 54
0.04 | 11.4 | A4 | 28 | 48 | 54 | 65
0.06 | 2.5 | A4 | 31 | 77 | 14 | 69
0.03 | 3.3 | A4 | 94 | 80 | 15 | 71
0.04 | 25 | A4 | 79 | 158 | 14 | 73
0.7 | 2.1 | A4 | 82 | 223 | 6 | 73
0.4 | 0.25 | A4 | 11 | 14 | 3 | 75
0.06 | 2.7 | A4 | 30 | 88 | 9 | 76
0.04 | 21.5 | A4 | 63 | 62 | 19 | 76
0.1
0.01
0.1
0.05
0.01
0.007
0.03
0.02
0.1
0.04
0.05
0.01
0.1
0.09
0.009
0.01
0.03
3.9
0.008
0.008
0.1
0.4
0.03
0.06
0.01
0.1
0.05
0.01
2.4
0.1
0.04
0.04
0.07
0.07
0.08
0.05
0.009
0.005
0.17
0.05
0.04
0.07
0.01
0.02
0.07
0.01
0.02
0.07
0.01
0.01
0.06
0.07
0.02
0.01
0.04
0.02
0.06
0.02
0.01
0.01
0.007
0.1
0.7
1.9
1.1
1.2
3.7
0.07
0.03
0.05
0.02
0.01
0.3
0.1
0.08
0.02
0.1
0.1
0.03
0.009
0.02
0.01
0.03
0.1
0.08
0.02
0.01
0.02
0.009
0.1
0.02
0.006
0.007
0.006
0.004
0.003
0.02
0.008
0.02
0.2
0.1