Spreadsheet: 884250d1733331371-extracting-data-with-multiple-criteria-extracting-data-with-multiple-criteria
Sheet: Sheet1

Year | Pos | [NAME] | Fld% | Rtot | RF/9 | Awards |  | Season | Age | Team | Lg | Pos | G | GS | CG | [NAME] | Ch | PO | A | E | DP | Fld% | lgFld% | Rtot | Rtot/yr | RF/9 | lgRF9 | RF/G | lgRFG | PB | WP | SB | CS | Pick | Awards |  |  | Trying to auto-populate data from the right array (I3:AJ75)into the chart (A2:G8), based on the year (A3:A7) and position (B8).  I've tried different variations of XLOOKUP, IF/ANDs, and [NAME], but just can't get my old brain to put any of these together in the proper sequence.  Maybe I'm just making it harder than it is...  [NAME] is to see how many "[NAME]" was played in a specific year at 3B position. If I can get that formula, then can expand it to the other columns.  The data array is not final...I will be updating the data as I move to other players.  I just need a jump-start!  Thanks!
1967 |  |  |  |  |  |  |  | 1968 | 27 | MIN | AL | 1B | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0.99 | 0 | 360 | 9 | 9.9 | 1 | 9.5 |  |  |  |  |  | MVP-23
1968 |  |  |  |  |  |  |  | 1965 | 24 | MIN | AL | 2B | 4 | 1 | 1 | 14.2 | 10 | 2 | 6 | 2 | 2 | 0.8 | 0.978 | 0 | -8 | 4.91 | 5.09 | 2 | 5.05
1969 |  |  |  |  |  |  |  | 1966 | 25 | MIN | AL | 2B | 76 | 73 | 70 | 644.1 | 367 | 154 | 205 | 8 | 33 | 0.978 | 0.975 | 13 | 24 | 5.01 | 5.09 | 4.72 | 5.09
1970 |  |  |  |  |  |  |  | 1967 | 26 | MIN | AL | 2B | 36 | 31 | 19 | 270.1 | 139 | 69 | 66 | 4 | 11 | 0.971 | 0.979 | -1 | -6 | 4.49 | 4.95 | 3.75 | 4.96 |  |  |  |  |  | MVP-7
1971 |  |  |  |  |  |  |  | 1968 | 27 | MIN | AL | 2B | 18 | 12 | 5 | 97.1 | 55 | 29 | 24 | 2 | 6 | 0.964 | 0.977 | -2 | -23 | 4.9 | 5.1 | 2.94 | 5.08 |  |  |  |  |  | MVP-23
 | 3B |  |  |  |  |  |  | 1969 | 28 | MIN | AL | 2B | 41 | 33 | 25 | 316.1 | 184 | 78 | 99 | 7 | 25 | 0.962 | 0.976 | 0 | -1 | 5.04 | 5.21 | 4.32 | 5.21 |  |  |  |  |  | MVP-17
 |  |  |  |  |  |  |  | 1970 | 29 | MIN | AL | 2B | 8 | 6 | 4 | 56 | 29 | 17 | 10 | 2 | 5 | 0.931 | 0.979 | -3 | -62 | 4.34 | 5.35 | 3.38 | 5.33 |  |  |  |  |  | MVP-18
 |  |  |  |  |  |  |  | 1971 | 30 | MIN | AL | 2B | 2 | 0 | 0 | 10 | 5 | 1 | 4 | 0 | 1 | 1 | 0.98 | 0 | 12 | 4.5 | 5.31 | 2.5 | 5.3 |  |  |  |  |  | MVP-24
 |  |  |  |  |  |  |  | 1973 | 32 | PHI | NL | 2B | 22 | 20 | 6 | 131.1 | 98 | 39 | 56 | 3 | 24 | 0.969 | 0.98 | 1 | 8 | 6.51 | 5.52 | 4.32 | 5.52
 |  |  |  |  |  |  |  | 1975 | 34 | 2TM | AL | 2B | 5 | 2 | 1 | 20 | 5 | 2 | 3 | 0 | 0 | 1 | 0.974 | -1 | -36 | 2.25 | 5.4 | 1 | 5.38
 |  |  |  |  |  |  |  | 1975 | 34 | TEX | AL | 2B | 1 | 1 | 1 | 9 | 3 | 1 | 2 | 0 | 0 | 1 | 0.973 | 0 | -13 | 3 | 5.4 | 3 | 5.4
 |  |  |  |  |  |  |  | 1975 | 34 | OAK | AL | 2B | 4 | 1 | 0 | 11 | 2 | 1 | 1 | 0 | 0 | 1 | 0.975 | -1 | -55 | 1.64 | 5.4 | 0.5 | 5.38
 |  |  |  |  |  |  |  | 1976 | 35 | NYY | AL | 2B | 3 | 2 | 1 | 16 | 12 | 4 | 8 | 0 | 2 | 1 | 0.975 | 1 | 105 | 6.75 | 5.4 | 4 | 5.43
 |  |  |  |  |  |  |  | 1965 | 24 | MIN | AL | 3B | 2 | 1 | 1 | 17 | 9 | 0 | 8 | 1 | 0 | 0.889 | 0.96 | 1 | 71 | 4.24 | 3.12 | 4 | 3.1
 |  |  |  |  |  |  |  | 1967 | 26 | MIN | AL | 3B | 70 | 56 | 48 | 520 | 170 | 60 | 101 | 9 | 8 | 0.947 | 0.955 | -4 | -9 | 2.79 | 3.13 | 2.3 | 3.14 |  |  |  |  |  | MVP-7
 |  |  |  |  |  |  |  | 1968 | 27 | MIN | AL | 3B | 75 | 67 | 35 | 545.2 | 209 | 48 | 147 | 14 | 8 | 0.933 | 0.951 | 2 | 5 | 3.22 | 3.05 | 2.6 | 3.04 |  |  |  |  |  | MVP-23
 |  |  |  |  |  |  |  | 1969 | 28 | MIN | AL | 3B | 20 | 14 | 7 | 134.2 | 40 | 12 | 26 | 2 | 2 | 0.95 | 0.955 | -1 | -10 | 2.54 | 3.16 | 1.9 | 3.15 |  |  |  |  |  | MVP-17
 |  |  |  |  |  |  |  | 1970 | 29 | MIN | AL | 3B | 4 | 4 | 4 | 39 | 8 | 2 | 3 | 3 | 0 | 0.625 | 0.949 | -3 | -92 | 1.15 | 3.07 | 1.25 | 3.05 |  |  |  |  |  | MVP-18
 |  |  |  |  |  |  |  | 1971 | 30 | MIN | AL | 3B | 7 | 5 | 3 | 45.1 | 14 | 3 | 9 | 2 | 1 | 0.857 | 0.956 | -1 | -34 | 2.38 | 3.04 | 1.71 | 3.03 |  |  |  |  |  | MVP-24
 |  |  |  |  |  |  |  | 1973 | 32 | PHI | NL | 3B | 46 | 39 | 25 | 333 | 97 | 34 | 56 | 7 | 7 | 0.928 | 0.946 | -7 | -26 | 2.43 | 2.88 | 1.96 | 2.88
 |  |  |  |  |  |  |  | 1975 | 34 | OAK | AL | 3B | 3 | 0 | 0 | 7 | 2 | 1 | 1 | 0 | 1 | 1 | 0.955 | 0 | 0 | 2.57 | 3.21 | 0.67 | 3.17
 |  |  |  |  |  |  |  | 1968 | 27 | MIN | AL | C | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0.99 | 0 | 0 | 9 | 7.2 | 1 | 6.9 | 0 | 0 | 0 | 0 | 0 | MVP-23
 |  |  |  |  |  |  |  | 1965 | 24 | MIN | AL | CF | 2 | 2 | 1 | 12 | 3 | 3 | 0 | 0 | 0 | 1 | 0.98 | 0 | -30 | 2.25 | 2.4 | 1.5 | 2.4
 |  |  |  |  |  |  |  | 1966 | 25 | MIN | AL | CF | 20 | 17 | 16 | 153 | 47 | 47 | 0 | 0 | 0 | 1 | 0.986 | 1 | 10 | 2.76 | 2.52 | 2.35 | 2.52
 |  |  |  |  |  |  |  | 1967 | 26 | MIN | AL | CF | 64 | 60 | 46 | 501 | 144 | 140 | 3 | 1 | 1 | 0.993 | 0.981 | -3 | -7 | 2.57 | 2.47 | 2.23 | 2.47 |  |  |  |  |  | MVP-7
 |  |  |  |  |  |  |  | 1968 | 27 | MIN | AL | CF | 36 | 29 | 27 | 269.1 | 86 | 81 | 4 | 1 | 1 | 0.988 | 0.986 | 5 | 24 | 2.84 | 2.53 | 2.36 | 2.52 |  |  |  |  |  | MVP-23
 |  |  |  |  |  |  |  | 1969 | 28 | MIN | AL | CF | 69 | 65 | 48 | 551 | 187 | 177 | 6 | 4 | 3 | 0.979 | 0.982 | 8 | 18 | 2.99 | 2.5 | 2.65 | 2.5 |  |  |  |  |  | MVP-17
 |  |  |  |  |  |  |  | 1970 | 29 | MIN | AL | CF | 132 | 125 | 96 | 1041 | 334 | 316 | 10 | 8 | 1 | 0.976 | 0.985 | 5 | 5 | 2.82 | 2.62 | 2.47 | 2.61 |  |  |  |  |  | MVP-18
 |  |  |  |  |  |  |  | 1971 | 30 | MIN | AL | CF | 42 | 33 | 8 | 237 | 84 | 81 | 2 | 1 | 0 | 0.988 | 0.983 | 7 | 33 | 3.15 | 2.73 | 1.98 | 2.72 |  |  |  |  |  | MVP-24
 |  |  |  |  |  |  |  | 1972 | 31 | MIN | AL | CF | 5 | 2 | 1 | 21.1 | 5 | 5 | 0 | 0 | 0 | 1 | 0.986 | 0 | -11 | 2.11 | 2.66 | 1 | 2.64
 |  |  |  |  |  |  |  | 1973 | 32 | PHI | NL | CF | 3 | 2 | 2 | 21 | 9 | 9 | 0 | 0 | 0 | 1 | 0.98 | 2 | 91 | 3.86 | 2.61 | 3 | 2.63
 |  |  |  |  |  |  |  | 1974 | 33 | TEX | AL | CF | 88 | 84 | 51 | 680.1 | 201 | 190 | 8 | 3 | 2 | 0.985 | 0.986 | -15 | -26 | 2.62 | 2.93 | 2.25 | 2.92
 |  |  |  |  |  |  |  | 1975 | 34 | TEX | AL | CF | 6 | 6 | 6 | 56 | 21 | 20 | 0 | 1 | 0 | 0.952 | 0.983 | -1 | -24 | 3.21 | 2.84 | 3.33 | 2.83
 |  |  |  |  |  |  |  | 1976 | 35 | OAK | AL | CF | 2 | 0 | 0 | 10 | 3 | 3 | 0 | 0 | 0 | 1 | 0.983 | 0 | 24 | 2.7 | 2.97 | 1.5 | 3
 |  |  |  |  |  |  |  | 1966 | 25 | MIN | AL | LF | 4 | 4 | 2 | 30 | 9 | 7 | 2 | 0 | 1 | 1 | 0.98 | 1 | 36 | 2.7 | 1.83 | 2.25 | 1.83
 |  |  |  |  |  |  |  | 1967 | 26 | MIN | AL | LF | 10 | 6 | 5 | 59.2 | 21 | 20 | 1 | 0 | 1 | 1 | 0.976 | 4 | 74 | 3.17 | 1.87 | 2.1 | 1.87 |  |  |  |  |  | MVP-7
 |  |  |  |  |  |  |  | 1968 | 27 | MIN | AL | LF | 37 | 15 | 10 | 160 | 39 | 35 | 0 | 4 | 0 | 0.897 | 0.978 | 1 | 4 | 1.97 | 1.85 | 0.95 | 1.84 |  |  |  |  |  | MVP-23
 |  |  |  |  |  |  |  | 1969 | 28 | MIN | AL | LF | 40 | 3 | 3 | 119.1 | 31 | 29 | 2 | 0 | 0 | 1 | 0.978 | 2 | 20 | 2.34 | 2 | 0.78 | 1.99 |  |  |  |  |  | MVP-17
 |  |  |  |  |  |  |  | 1970 | 29 | MIN | AL | LF | 45 | 21 | 13 | 243.1 | 44 | 43 | 0 | 1 | 0 | 0.977 | 0.978 | 0 | -1 | 1.59 | 1.81 | 0.96 | 1.8 |  |  |  |  |  | MVP-18
 |  |  |  |  |  |  |  | 1971 | 30 | MIN | AL | LF | 104 | 81 | 67 | 747.1 | 195 | 186 | 6 | 3 | 1 | 0.985 | 0.981 | 2 | 3 | 2.31 | 1.93 | 1.85 | 1.92 |  |  |  |  |  | MVP-24
 |  |  |  |  |  |  |  | 1972 | 31 | MIN | AL | LF | 41 | 38 | 31 | 335 | 67 | 66 | 1 | 0 | 0 | 1 | 0.98 | 1 | 4 | 1.8 | 1.89 | 1.63 | 1.89
 |  |  |  |  |  |  |  | 1973 | 32 | PHI | NL | LF | 6 | 2 | 0 | 33 | 4 | 3 | 0 | 1 | 0 | 0.75 | 0.978 | -1 | -47 | 0.82 | 2.05 | 0.5 | 2.05
 |  |  |  |  |  |  |  | 1974 | 33 | TEX | AL | LF | 68 | 41 | 35 | 409.1 | 122 | 117 | 1 | 4 | 0 | 0.967 | 0.974 | 6 | 17 | 2.59 | 2.12 | 1.74 | 2.11
 |  |  |  |  |  |  |  | 1975 | 34 | TEX | AL | LF | 25 | 23 | 16 | 196 | 41 | 36 | 1 | 4 | 0 | 0.902 | 0.977 | -4 | -21 | 1.7 | 2.18 | 1.48 | 2.17
 |  |  |  |  |  |  |  | 1976 | 35 | OAK | AL | LF | 14 | 5 | 4 | 65 | 15 | 14 | 0 | 1 | 0 | 0.933 | 0.978 | 0 | -7 | 1.94 | 2.23 | 1 | 2.24
 |  |  |  |  |  |  |  | 1965 | 24 | MIN | AL | OF | 2 | 2 | 1 | 12 | 3 | 3 | 0 | 0 | 0 | 1 | 0.977 | 0 | -30 | 2.25 | 2.03 | 1.5 | 2.05
 |  |  |  |  |  |  |  | 1966 | 25 | MIN | AL | OF | 24 | 21 | 18 | 183 | 55 | 53 | 2 | 0 | 1 | 1 | 0.982 | 2 | 14 | 2.7 | 2.1 | 2.29 | 2.1
 |  |  |  |  |  |  |  | 1967 | 26 | MIN | AL | OF | 74 | 70 | 55 | 598.2 | 175 | 169 | 5 | 1 | 3 | 0.994 | 0.98 | 1 | 3 | 2.62 | 2.05 | 2.35 | 2.06 |  |  |  |  |  | MVP-7
 |  |  |  |  |  |  |  | 1968 | 27 | MIN | AL | OF | 78 | 52 | 43 | 502.2 | 147 | 138 | 4 | 5 | 1 | 0.966 | 0.981 | 6 | 14 | 2.54 | 2.08 | 1.82 | 2.07 |  |  |  |  |  | MVP-23
 |  |  |  |  |  |  |  | 1969 | 28 | MIN | AL | OF | 113 | 76 | 58 | 748 | 238 | 225 | 9 | 4 | 3 | 0.983 | 0.978 | 11 | 18 | 2.82 | 2.13 | 2.07 | 2.13 |  |  |  |  |  | MVP-17
 |  |  |  |  |  |  |  | 1970 | 29 | MIN | AL | OF | 151 | 146 | 109 | 1288.1 | 391 | 370 | 12 | 9 | 1 | 0.977 | 0.98 | 5 | 4 | 2.67 | 2.14 | 2.53 | 2.13 |  |  |  |  |  | MVP-18
 |  |  |  |  |  |  |  | 1971 | 30 | MIN | AL | OF | 154 | 150 | 105 | 1315.1 | 367 | 348 | 14 | 5 | 3 | 0.986 | 0.982 | 9 | 8 | 2.48 | 2.24 | 2.35 | 2.22 |  |  |  |  |  | MVP-24
 |  |  |  |  |  |  |  | 1972 | 31 | MIN | AL | OF | 139 | 134 | 117 | 1194.1 | 302 | 287 | 10 | 5 | 2 | 0.983 | 0.983 | 14 | 14 | 2.24 | 2.22 | 2.14 | 2.21
 |  |  |  |  |  |  |  | 1973 | 32 | PHI | NL | OF | 24 | 20 | 7 | 161.2 | 43 | 40 | 1 | 2 | 1 | 0.953 | 0.977 | 1 | 5 | 2.28 | 2.23 | 1.71 | 2.23
 |  |  |  |  |  |  |  | 1974 | 33 | TEX | AL | OF | 135 | 133 | 93 | 1171.2 | 351 | 331 | 13 | 7 | 3 | 0.98 | 0.98 | -8 | -8 | 2.64 | 2.41 | 2.55 | 2.4
 |  |  |  |  |  |  |  | 1975 | 34 | TEX | AL | OF | 31 | 30 | 22 | 259 | 62 | 56 | 1 | 5 | 0 | 0.919 | 0.979 | -5 | -23 | 1.98 | 2.37 | 1.84 | 2.36
 |  |  |  |  |  |  |  | 1976 | 35 | OAK | AL | OF | 20 | 8 | 6 | 103 | 24 | 23 | 0 | 1 | 0 | 0.958 | 0.981 | 0 | 0 | 2.01 | 2.47 | 1.15 | 2.48
 |  |  |  |  |  |  |  | 1968 | 27 | MIN | AL | P | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 1.8 | 0 | 1.9 |  | 0 | 0 | 0 | 0 | MVP-23
 |  |  |  |  |  |  |  | 1967 | 26 | MIN | AL | RF | 6 | 4 | 4 | 38 | 9 | 8 | 1 | 0 | 1 | 1 | 0.981 | 0 | 13 | 2.13 | 1.82 | 1.5 | 1.82 |  |  |  |  |  | MVP-7
 |  |  |  |  |  |  |  | 1968 | 27 | MIN | AL | RF | 11 | 8 | 6 | 73.1 | 21 | 20 | 1 | 0 | 0 | 1 | 0.977 | 0 | 2 | 2.58 | 1.88 | 1.91 | 1.87 |  |  |  |  |  | MVP-23
 |  |  |  |  |  |  |  | 1969 | 28 | MIN | AL | RF | 8 | 8 | 7 | 77.2 | 19 | 19 | 0 | 0 | 0 | 1 | 0.974 | 1 | 11 | 2.2 | 1.91 | 2.38 | 1.91 |  |  |  |  |  | MVP-17
 |  |  |  |  |  |  |  | 1970 | 29 | MIN | AL | RF | 2 | 0 | 0 | 4 | 1 | 1 | 0 | 0 | 0 | 1 | 0.97 | 0 | 60 | 2.25 | 2.03 | 0.5 | 1.95 |  |  |  |  |  | MVP-18
 |  |  |  |  |  |  |  | 1971 | 30 | MIN | AL | RF | 47 | 36 | 30 | 331 | 87 | 81 | 5 | 1 | 2 | 0.989 | 0.98 | 1 | 2 | 2.34 | 2.05 | 1.83 | 2.04 |  |  |  |  |  | MVP-24
 |  |  |  |  |  |  |  | 1972 | 31 | MIN | AL | RF | 100 | 94 | 85 | 838 | 232 | 218 | 9 | 5 | 2 | 0.978 | 0.98 | 13 | 19 | 2.44 | 2.12 | 2.27 | 2.11
 |  |  |  |  |  |  |  | 1973 | 32 | PHI | NL | RF | 16 | 16 | 5 | 107.2 | 34 | 31 | 1 | 2 | 0 | 0.941 | 0.973 | 0 | 4 | 2.67 | 2.01 | 2 | 2.01
 |  |  |  |  |  |  |  | 1974 | 33 | TEX | AL | RF | 12 | 8 | 7 | 82 | 26 | 23 | 3 | 0 | 1 | 1 | 0.976 | 1 | 10 | 2.85 | 2.18 | 2.17 | 2.17
 |  |  |  |  |  |  |  | 1975 | 34 | TEX | AL | RF | 1 | 1 | 0 | 7 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | -69 | 0 | 2.06 | 0 | 2.1
 |  |  |  |  |  |  |  | 1976 | 35 | OAK | AL | RF | 4 | 3 | 2 | 28 | 7 | 7 | 0 | 0 | 0 | 1 | 0.98 | 0 | 9 | 2.25 | 2.22 | 1.75 | 2.23
 |  |  |  |  |  |  |  | 1965 | 24 | MIN | AL | SS | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 4.95 | 0 | 4.7
 |  |  |  |  |  |  |  | 1966 | 25 | MIN | AL | SS | 31 | 27 | 27 | 262 | 120 | 47 | 67 | 6 | 10 | 0.95 | 0.96 | -1 | -6 | 3.92 | 4.79 | 3.68 | 4.78
 |  |  |  |  |  |  |  | 1967 | 26 | MIN | AL | SS | 9 | 5 | 2 | 44 | 24 | 9 | 12 | 3 | 1 | 0.875 | 0.963 | -1 | -33 | 4.3 | 4.62 | 2.33 | 4.63 |  |  |  |  |  | MVP-7
 |  |  |  |  |  |  |  | 1968 | 27 | MIN | AL | SS | 35 | 20 | 9 | 185.2 | 95 | 31 | 59 | 5 | 9 | 0.947 | 0.962 | 0 | -2 | 4.36 | 4.79 | 2.57 | 4.77 |  |  |  |  |  | MVP-23
 |  |  |  |  |  |  |  | 1975 | 34 | OAK | AL | SS | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0.96 | 0 | 0 | 9 | 4.5 | 1 | 4.8