Spreadsheet: 677713d1589480110-search-multiple-columns-return-corresponding-value-search1
Sheet: Sheet1

Round 1 |  |  | Round 2 |  |  | Round 3 |  |  | Round 4 |  |  | Round 5
Pick | Value | Salary | Pick | Value | Salary | Pick | Value | Salary | Pick | Value | Salary | Pick | Value | Salary
1.01 | 3000 | 12.8 | 2.01 | 525 | 1.5 | 3.01 | 220 | 0.8 | 4.01 | 60 | 0.5 | 5.01 | 23 | 0.3 |  |  | Pick to Search | 2.18
1.02 | 2600 | 12 | 2.02 | 510 | 1.5 | 3.02 | 215 | 0.8 | 4.02 | 58 | 0.5 | 5.02 | 22 | 0.3 |  |  | Value to Return
1.03 | 2200 | 11.2 | 2.03 | 495 | 1.5 | 3.03 | 210 | 0.8 | 4.03 | 56 | 0.5 | 5.03 | 21 | 0.3
1.04 | 2000 | 10.4 | 2.04 | 480 | 1.5 | 3.04 | 205 | 0.8 | 4.04 | 54 | 0.5 | 5.04 | 20 | 0.3
1.05 | 1800 | 9.6 | 2.05 | 465 | 1.5 | 3.05 | 200 | 0.8 | 4.05 | 52 | 0.5 | 5.05 | 19 | 0.3 |  |  | Pick to Search | 5.05
1.06 | 1700 | 8.8 | 2.06 | 450 | 1.5 | 3.06 | 195 | 0.8 | 4.06 | 50 | 0.5 | 5.06 | 18 | 0.3 |  |  | Value to Return
1.07 | 1600 | 8 | 2.07 | 440 | 1.5 | 3.07 | 190 | 0.8 | 4.07 | 49 | 0.5 | 5.07 | 17 | 0.3
1.08 | 1500 | 7.2 | 2.08 | 430 | 1.5 | 3.08 | 185 | 0.8 | 4.08 | 48 | 0.5 | 5.08 | 16 | 0.3
1.09 | 1400 | 6.4 | 2.09 | 420 | 1.5 | 3.09 | 180 | 0.8 | 4.09 | 47 | 0.5 | 5.09 | 15 | 0.3
1.1 | 1300 | 5.6 | 2.1 | 410 | 1.5 | 3.1 | 175 | 0.8 | 4.1 | 46 | 0.5 | 5.1 | 14 | 0.3
1.11 | 1200 | 4.8 | 2.11 | 400 | 1.2 | 3.11 | 170 | 0.7 | 4.11 | 45 | 0.5 | 5.11 | 13.5 | 0.3
1.12 | 1150 | 4.6 | 2.12 | 390 | 1.2 | 3.12 | 165 | 0.7 | 4.12 | 44 | 0.5 | 5.12 | 13 | 0.3
1.13 | 1100 | 4.4 | 2.13 | 380 | 1.2 | 3.13 | 160 | 0.7 | 4.13 | 43 | 0.5 | 5.13 | 12.5 | 0.3
1.14 | 1050 | 4.3 | 2.14 | 370 | 1.2 | 3.14 | 155 | 0.7 | 4.14 | 42 | 0.5 | 5.14 | 12 | 0.3
1.15 | 1000 | 4.2 | 2.15 | 360 | 1.2 | 3.15 | 150 | 0.7 | 4.15 | 41 | 0.5 | 5.15 | 11.5 | 0.3
1.16 | 950 | 4.1 | 2.16 | 350 | 1.2 | 3.16 | 145 | 0.7 | 4.16 | 40 | 0.5 | 5.16 | 11 | 0.3
1.17 | 925 | 3.5 | 2.17 | 340 | 1.2 | 3.17 | 140 | 0.7 | 4.17 | 39 | 0.4 | 5.17 | 10.5 | 0.3
1.18 | 900 | 3.4 | 2.18 | 330 | 1.2 | 3.18 | 135 | 0.7 | 4.18 | 38 | 0.4 | 5.18 | 10 | 0.3
1.19 | 875 | 3.3 | 2.19 | 320 | 1.2 | 3.19 | 130 | 0.7 | 4.19 | 37 | 0.4 | 5.19 | 9.5 | 0.3
1.2 | 850 | 3.2 | 2.2 | 310 | 1.2 | 3.2 | 125 | 0.7 | 4.2 | 36 | 0.4 | 5.2 | 9 | 0.3
1.21 | 825 | 3.1 | 2.21 | 300 | 1.2 | 3.21 | 120 | 0.7 | 4.21 | 35 | 0.4 | 5.21 | 8.5 | 0.3
1.22 | 800 | 3 | 2.22 | 290 | 1 | 3.22 | 115 | 0.6 | 4.22 | 34 | 0.4 | 5.22 | 8 | 0.3
1.23 | 775 | 2.9 | 2.23 | 280 | 1 | 3.23 | 110 | 0.6 | 4.23 | 33 | 0.4 | 5.23 | 7.5 | 0.3
1.24 | 750 | 2.8 | 2.24 | 270 | 1 | 3.24 | 105 | 0.6 | 4.24 | 32 | 0.4 | 5.24 | 7 | 0.3
1.25 | 725 | 2.7 | 2.25000000000001 | 260 | 1 | 3.25000000000001 | 100 | 0.6 | 4.25000000000001 | 31 | 0.4 | 5.25000000000001 | 6.5 | 0.3
1.26 | 700 | 2.6 | 2.26000000000001 | 255 | 1 | 3.26000000000001 | 95 | 0.6 | 4.26000000000001 | 30 | 0.4 | 5.26000000000001 | 6 | 0.3
1.27 | 675 | 2.5 | 2.27000000000001 | 250 | 1 | 3.27000000000001 | 90 | 0.6 | 4.27000000000001 | 29 | 0.4 | 5.27000000000001 | 5.5 | 0.3
1.28 | 650 | 2.4 | 2.28000000000001 | 245 | 1 | 3.28000000000001 | 85 | 0.6 | 4.28000000000001 | 28 | 0.4 | 5.28000000000001 | 5 | 0.3
1.29 | 625 | 2.3 | 2.29000000000001 | 240 | 1 | 3.29000000000001 | 80 | 0.6 | 4.29000000000001 | 27 | 0.4 | 5.29000000000001 | 4.5 | 0.3
1.3 | 600 | 2.2 | 2.30000000000001 | 235 | 1 | 3.30000000000001 | 75 | 0.6 | 4.30000000000001 | 26 | 0.4 | 5.30000000000001 | 4 | 0.3
1.31 | 575 | 2.1 | 2.31000000000001 | 230 | 1 | 3.31000000000001 | 70 | 0.6 | 4.31000000000001 | 25 | 0.4 | 5.31000000000001 | 3.5 | 0.3
1.32 | 550 | 2 | 2.32000000000001 | 225 | 1 | 3.32000000000001 | 65 | 0.6 | 4.32000000000001 | 24 | 0.4 | 5.32000000000001 | 3 | 0.3