Spreadsheet: 793410d1661451373-upgrade-from-vlookup-to-index-and-match-excel-help
Sheet: Grid

Attendance | 2012 |  | 2018
 | 2014 |  | 2019
 | 2015 |  | 2020
 | 2016 |  | 2021
 | 2017 |  | 2022
 |  | Already Played!
 | MEMBER |  |  | PLY
 |  |  |  |  |  |  | 21 | 21 |  |  |  | 19 |  | 21 |  |  |  | 19 | 19 | 19 |  |  |  | 21 | 21 | 22 | 21 | 21 | 21 | 20 | 19 | 21 | 20 | 22 | 20 | 21 |  | 21 | 21 | 21 | 22 |  | 21 | 22 | 21 | 21 | 21 | 19 | 21 | 19 | 21 | 21 | 21 | 21 | 21 | 22 | 21 | 22 | 21 |  | 21 | 21 | 19 | 21 | 20 | 20 | 21 | z
 |  |  |  |  |  |  |  | 19 |  |  |  | 19 |  | 19 |  |  |  | 19 | 19 | 16 |  |  |  |  |  | 21 | 19 | 19 | 21 | 21 | 19 | 21 |  | 19 |  | 21 |  | 20 | 22 | 22 | 19 |  |  |  | 21 | 21 | 20 |  |  | 19 |  | 22 |  | 21 | 19 | 19 |  | 18 |  |  | 21 | 21 | 19 |  | 18 | 19 | z
 |  |  |  |  |  |  | 21 | 19 |  |  |  | 19 |  |  | 19 |  | 22 | 20 | 17 | 21 |  |  | 22 | 22 | 22 | 20 | 21 | 22 | 21 | 22 |  | 21 | 20 | 22 | 20 | 22 |  | 22 | 22 | 22 | 22 |  | 22 | 22 | 22 | 21 | 22 | 21 |  | 21 | 22 | 21 | 19 | 21 | 22 | 21 | 22 | 22 | 22 |  | 21 |  | 22 | 21 | 19 | z
 |  |  |  |  |  |  |  | 18 |  |  |  | 19 |  |  | 18 |  |  | 19 |  | 19 |  |  |  |  |  | 21 | 20 | 21 | 21 | 21 | 18 | 21 | 21 | 21 |  |  |  | 19 | 21 | 22 | 19 |  | 19 | 20 | 21 | 20 | 21 | 22 |  | 19 | 22 | 20 |  | 20 | 20 | 20 |  | 21 | 21 | 21 | 20 |  | 19 |  | Z
 |  |  |  |  |  |  |  | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 |  | 21 | 21 | 21 | 22 | 21 |  | 20 | 21 | 21 |  | 21 |  | 22 | 21 | 22 |  |  | 22 |  |  | 21 |  |  | 21 |  | 22 | 21 | 22 |  |  | 20 |  |  |  |  | 22 |  |  | z
 |  |  |  |  | 22 |  | 21 | 21 |  |  |  | 18 |  |  | 18 |  |  | 19 | 17 | 17 |  |  |  | 22 | 20 | 22 | 22 | 22 | 20 | 21 | 18 | 22 | 19 | 22 | 17 | 19 |  | 22 | 20 | 19 | 19 | 22 | 21 | 20 | 21 |  | 20 | 20 |  | 19 | 21 | 19 |  | 20 | 22 | 19 | 19 | 19 | 19 |  |  |  | z
 |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  | 21 | 21 |  | 22 |  | 22 |  | 21 |  | 22 |  |  |  | 21 | 22 | 22 | 22 | 21 | 21 | 21 |  |  |  |  |  | 21 |  | 21 |  | 21 |  | 21 |  | 21 |  |  | 21 | z
 |  |  |  |  |  | 22 | 21 | 21 |  |  | 22 |  |  |  |  |  |  | 21 |  |  |  |  |  | 22 | 21 | 21 | 22 | 23 | 22 | 22 |  | 22 | 21 | 22 | 21 | 21 |  | 21 | 22 | 22 | 22 | 22 | 23 | 22 | 22 | 22 | 21 |  |  |  | 21 | 22 | 22 | 21 |  | 21 | 21 | 21 | 21 |  | Z
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 21 | 19 | 22 |  |  |  | 22 | 19 | 19 | 21 |  |  | 21 | 22 | 22 | 21 |  |  |  | 22 |  |  |  |  | 22 |  |  |  | Z
 |  |  |  |  |  |  |  | 22 | 22 |  |  | 18 |  |  | 18 |  |  | 19 |  | 21 |  |  |  | 22 | 21 | 21 | 21 | 21 | 22 | 21 | 18 | 21 | 21 | 21 | 20 | 22 |  | 21 | 21 | 20 | 21 |  | 21 | 22 | 21 | 21 | 19 |  |  |  | 21 | 19 |  | 22 | 19 | 20 | 20 | 22 | Z
 |  |  |  |  |  |  | 21 | 18 |  |  |  | 18 |  |  | 18 |  |  | 19 |  | 20 |  |  |  | 20 | 21 | 19 | 21 | 22 | 18 | 22 | 18 | 21 | 19 | 21 | 18 | 22 |  | 21 | 19 | 20 | 21 |  | 22 | 22 | 21 |  |  |  |  |  | 22 | 21 |  | 22 | 18 | 22 |  | z
 |  |  |  |  |  |  |  | 21 |  |  |  | 19 |  | 21 | 18 |  |  | 20 |  | 22 |  |  |  | 22 | 22 | 22 | 22 | 22 | 21 | 21 |  | 22 |  | 22 |  | 22 | 20 | 21 | 22 | 21 | 21 |  | 21 | 21 | 22 | 21 | 22 | 20 | 20 | 22 | 22 | 21 |  | 22 | 22 | 21 | z
 |  |  |  |  |  |  |  | 17 |  |  |  | 19 |  | 21 | 17 |  |  | 19 |  | 21 |  |  |  | 19 | 21 | 21 | 21 | 21 | 22 | 22 |  | 22 | 20 | 21 |  | 21 | 21 | 22 | 21 | 20 | 22 | 22 | 22 | 22 | 22 | 21 | 21 | 21 |  | 19 | 20 | 21 |  | 21 | 21 | z
 |  |  |  |  | 22 | 22 |  | 18 |  |  |  | 18 |  | 21 | 18 |  |  | 21 |  | 17 |  |  |  | 21 | 21 | 21 | 21 | 21 | 21 | 22 | 16 | 22 | 18 | 22 | 18 | 21 |  | 21 | 21 | 21 | 19 |  | 21 | 21 | 22 | 21 | 21 |  |  | 21 | 19 | 18 |  | 19 | z
 |  |  |  |  |  |  | 18 | 19 |  |  |  | 22 | 22 | 22 | 22 |  |  | 21 | 17 | 22 |  |  |  | 22 | 21 | 22 | 22 | 22 | 21 | 21 | 19 | 22 | 21 | 22 | 21 | 22 |  | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 21 | 21 | 18 |  | 22 | 21 | 22 | 21 | z
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 |  | 19 | 18 |  |  | 18 |  | 19 | 21 | 18 | 21 | 18 |  |  |  |  |  |  |  | 21 |  |  |  |  |  |  | 19 | 19 | z
 |  |  |  |  |  | 22 | 18 | 21 |  |  |  | 18 | 22 |  | 22 |  |  | 22 |  | 19 |  |  |  | 21 | 22 | 21 | 22 | 21 | 21 | 21 |  | 22 | 21 | 21 | 18 | 22 | 21 | 21 | 22 | 22 | 22 | 22 | 21 | 21 | 22 | 21 | 22 | 18 | 21 | 22 | 21 | z
 |  |  |  |  | 22 | 22 | 18 | 21 |  |  |  | 19 |  | 21 | 19 |  |  | 19 |  | 18 |  |  |  | 21 | 19 | 22 | 22 | 22 | 22 | 21 | 21 | 22 | 21 | 22 | 21 | 21 |  | 21 | 22 | 23 | 22 | 22 | 21 | 22 | 21 | 22 | 21 | 22 |  | 21 | z
 |  |  |  |  | 22 |  | 21 | 17 |  |  |  |  |  | 22 |  | 22 |  | 21 |  | 16 |  |  |  |  |  | 21 | 21 | 21 |  | 21 | 15 | 22 |  | 22 |  | 22 |  | 22 | 21 |  | 21 | 22 | 22 | 22 | 21 |  | 22 | 19 |  | Z
 |  |  |  |  |  |  | 22 |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  |  | 21 |  |  |  | 21 |  | 22 |  | 22 |  | 21 |  | 21 | 21 |  |  | z
 |  |  |  |  |  |  |  | 17 |  |  |  | 22 |  | 18 | 19 |  |  | 20 |  | 21 |  |  |  | 18 | 20 | 21 | 20 | 22 | 20 | 18 |  | 18 | 21 | 18 |  | 21 |  | 19 | 18 | 22 | 21 |  | 18 | 20 | 18 |  | 22 | z
 |  |  |  |  | 18 | 22 |  | 17 |  |  |  | 22 |  | 21 | 19 |  |  | 22 | 14 | 18 |  |  |  | 21 | 22 | 21 | 18 | 22 | 22 | 22 | 20 | 22 | 21 | 23 | 19 | 22 |  | 22 | 22 | 22 | 23 |  | 22 | 21 | 22 | 21 | Z
 |  |  |  |  |  | 19 |  |  |  |  | 22 |  |  |  |  |  |  | 21 |  |  |  |  |  |  | 19 | 22 | 21 | 21 | 22 | 21 |  | 21 |  | 22 |  | 21 |  | 21 | 22 | 20 |  |  | 22 | 22 | 22 | z
 |  |  |  |  | 18 | 22 |  | 21 |  |  |  | 20 |  | 22 | 19 |  |  | 21 | 18 | 19 |  |  |  | 21 | 22 | 22 | 20 | 21 | 22 | 23 |  | 22 | 19 | 21 |  | 22 | 21 | 22 | 22 | 21 | 22 | 21 | 21 | 22 | z
 |  |  |  |  | 22 | 22 |  | 19 |  |  |  | 19 |  |  | 19 |  |  | 22 | 18 | 18 |  |  |  | 22 | 21 | 22 | 22 | 22 | 22 | 22 |  | 22 | 22 | 22 | 19 | 21 |  | 21 | 22 | 22 | 22 |  | 22 | z
 |  |  |  |  |  | 22 |  | 19 |  |  | 22 | 19 |  |  |  |  |  | 22 |  | 19 |  |  |  | 21 | 21 | 22 | 21 | 22 | 22 | 22 |  | 23 | 21 | 22 |  | 22 |  | 22 | 22 | 22 | 22 | 22 | Z
 |  |  |  |  |  | 22 |  | 21 |  |  |  |  |  |  |  |  |  |  |  |  | 22 |  |  | 22 | 21 | 21 | 22 | 22 |  | 22 |  | 22 |  | 21 |  |  |  | 22 | 21 | 22 | 22 | z
 |  |  |  |  |  | 22 |  | 21 |  |  |  | 19 |  | 22 | 18 |  |  | 22 | 19 | 17 |  | 22 |  | 21 | 22 | 22 | 22 | 22 | 23 | 22 | 19 | 22 | 21 | 22 | 18 | 22 |  | 21 | 23 | 22 | z
 |  |  |  |  |  | 22 | 22 | 18 |  |  |  | 18 |  | 22 | 18 | 22 | 22 | 22 | 13 | 20 | 22 |  | 22 | 21 |  | 21 | 21 | 22 | 22 | 23 |  | 22 | 21 | 22 | 19 | 21 |  | 22 | 22 | Z
 |  |  |  |  |  | 22 | 18 | 21 |  |  |  | 19 |  | 22 | 19 |  |  | 22 | 19 | 18 |  |  |  | 22 | 21 | 22 | 21 | 22 | 22 | 23 | 19 | 23 | 21 | 22 | 19 | 22 |  | 22 | z
 |  |  |  |  |  | 22 |  | 19 |  |  |  | 18 |  | 21 | 19 |  |  | 21 | 18 | 19 |  |  |  | 21 | 22 | 22 | 22 | 21 | 22 | 20 | 19 | 22 | 22 | 21 | 18 | 20 |  | z
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 21 |  |  |  |  |  |  | z
 |  |  |  |  |  |  |  | 21 |  |  |  | 19 |  |  | 18 |  |  | 18 |  | 18 |  |  |  | 22 | 22 | 22 | 21 | 22 | 21 | 21 |  | 22 | 19 | 21 | 20 | z
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  |  |  |  |  |  |  |  |  |  |  | 21 | 18 | 20 | 18 | 20 |  | 20 |  | 20 | 21 | 18 | Z
 |  |  |  |  |  | 22 | 21 | 21 |  |  |  | 22 |  | 22 | 19 |  |  | 22 | 17 | 22 |  |  |  | 22 | 21 | 22 | 22 | 22 | 21 | 23 | 18 | 21 | 20 | z
 |  |  |  |  |  | 22 |  | 17 |  |  |  | 19 |  |  |  |  |  |  |  | 19 |  |  |  |  | 18 | 22 | 20 | 21 | 22 | 20 |  | 22 | z
 |  |  |  |  | 22 | 22 | 22 | 21 |  |  |  | 19 |  | 22 | 19 |  |  | 22 | 19 | 22 |  |  |  | 21 | 21 | 22 | 21 | 22 | 22 | 23 | 19 | z
 |  |  |  |  | 12 |  |  | 17 |  |  |  | 18 |  |  |  |  |  | 18 | 19 | 18 |  |  |  |  |  | 21 | 17 | 18 | 20 | 21 | z |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SCOTT LOOM
 |  |  |  |  | 18 | 23 | 21 | 19 |  |  |  | 19 |  | 22 | 19 | 22 |  | 21 | 18 | 19 | 22 |  |  | 21 | 21 | 21 | 21 | 23 | 23 | z
 |  |  |  |  |  |  |  | 22 | 22 |  |  | 20 |  | 21 | 19 |  |  | 22 |  | 18 |  |  |  | 21 | 20 | 22 | 20 | 23 | z
 |  |  |  |  |  | 22 |  | 18 |  |  |  | 22 |  | 21 | 18 | 22 |  | 22 | 18 | 21 |  |  |  | 22 | 21 | 22 | 22 | z
 |  |  |  |  | 22 |  |  | 18 |  |  |  | 19 |  | 22 | 18 |  |  | 21 | 18 | 19 |  | 22 |  | 22 | 22 | 22 | z
 |  |  |  |  |  | 22 | 18 | 21 |  |  |  | 19 |  | 18 | 19 |  |  | 21 | 18 | 19 |  |  |  | 21 | 21 | z
 |  |  |  |  |  | 22 |  | 18 |  |  |  | 19 |  |  | 19 |  |  | 21 |  | 19 |  | 22 |  | 22 | z
 |  |  |  |  |  |  | 18 | 21 |  |  |  | 20 |  | 22 |  |  |  | 18 |  | 20 |  |  |  | z
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  | z
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | z
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Z
 |  |  |  |  | 17 |  |  | 19 |  |  |  | 22 |  |  | 19 |  |  | 18 | 18 | z
 |  |  |  |  |  |  |  | 18 |  |  |  | 18 |  | 15 |  |  |  | 18 | z
 |  |  |  |  | 18 | 22 |  | 17 |  |  |  | 18 |  | 18 | 19 |  |  | Z
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | z
 |  |  |  |  | 22 |  |  |  |  |  |  |  |  | 22 |  | z
 |  |  |  |  |  |  |  | 18 |  |  |  | 19 | 22 |  | Z
 |  |  |  |  | 22 |  | 21 | 18 |  |  |  | 18 |  | z
 |  |  |  |  |  |  |  |  |  |  |  |  | Z
 |  |  |  |  |  |  |  | 19 |  |  |  | Z
 |  |  |  |  |  |  |  |  |  |  | z
 |  |  |  |  |  |  |  |  |  | z
 |  |  |  |  |  |  |  | 22 | z
 |  |  |  |  |  |  |  | z
 |  |  |  |  |  |  | z
 |  |  |  |  |  | z
 |  |  |  |  | z