Spreadsheet: 390945d1429808116-index-match-function-using-a-table-and-named-ranges-biv2
Sheet: SF Tournaments

Current
Year | Tournament | TournBudget | TournPaid | TournBB | TournPrice | TournQtr |  |  |  |  |  | Collegiate Showcase
2004-11-30 00:00:00 | Collegiate Showcase |  | 44 |  |  | 4Q |  |  |  |  |  | Labor Day
2005-11-30 00:00:00 | Collegiate Showcase |  |  |  |  | 4Q |  |  |  |  |  | Spring Classic
2006-11-30 00:00:00 | Collegiate Showcase |  | 68 |  |  | 4Q |  |  |  |  |  | Xtreme Cup
2007-11-30 00:00:00 | Collegiate Showcase |  | 72 |  |  | 4Q |  |  |  |  |  | Sounders FC
2008-11-30 00:00:00 | Collegiate Showcase |  | 69 |  |  | 4Q |  |  |  |  |  | [NAME]
2009-11-30 00:00:00 | Collegiate Showcase | 80 | 80 |  | 800 | 4Q |  |  |  |  |  | [NAME]
2010-11-30 00:00:00 | Collegiate Showcase | 80 | 82 |  | 825 | 4Q
2005-07-15 00:00:00 | Labor Day |  | 92 |  |  | 3Q |  | offset($B$2,0,0,counta($B:$b)-1)
2006-07-15 00:00:00 | Labor Day |  | 123 |  |  | 3Q
2007-07-15 00:00:00 | Labor Day |  | 125 |  |  | 3Q
2008-07-15 00:00:00 | Labor Day |  | 138 |  |  | 3Q
2009-07-15 00:00:00 | Labor Day |  | 157 |  | 495 | 3Q
2010-07-15 00:00:00 | Labor Day | 125 | 170 |  | 515 | 3Q
2011-07-15 00:00:00 | Labor Day | 140 | 141 |  | 550 | 3Q |  | =INDEX(sftourn,MATCH(ReportPeriod,sftourn[Report Period]), COLUMN(currentsftournpaid)):INDEX(sftourn, MATCH(tournname,sftourn[tournname]), COLUMN(currenttournpaid))
2012-07-15 00:00:00 | Labor Day | 35 | 25 |  | 450 | 3Q
2004-12-31 00:00:00 | Memorial Cup |  | 125 |  |  | 2Q
2005-12-31 00:00:00 | Memorial Cup |  | 123 |  |  | 2Q
2006-12-31 00:00:00 | Memorial Cup |  | 135 |  |  | 2Q
2007-12-31 00:00:00 | Memorial Cup |  |  |  |  | 2Q
2008-12-31 00:00:00 | Memorial Cup |  | 132 |  |  | 2Q
2009-12-31 00:00:00 | Memorial Cup |  | 76 |  | 495 | 2Q
2010-12-31 00:00:00 | Memorial Cup | 125 | 93 |  | 515 | 2Q
2011-12-31 00:00:00 | Memorial Cup | 100 | 91 |  | 525 | 2Q
2009-07-15 00:00:00 | Sounders Cup |  | 177 |  | 515 | 3Q
2010-07-15 00:00:00 | Sounders Cup | 155 | 120 |  | 700 | 3Q
2011-07-15 00:00:00 | Sounders Cup | 120 | 105 |  | 700 | 3Q
2012-07-15 00:00:00 | Sounders Cup | 100 | 132 |  | 595 | 3Q
2005-06-30 00:00:00 | Spring Classic |  | 100 |  |  | 2Q
2006-06-30 00:00:00 | Spring Classic |  |  |  |  | 2Q
2007-06-30 00:00:00 | Spring Classic |  |  |  |  | 2Q
2008-06-30 00:00:00 | Spring Classic |  | 190 |  |  | 2Q
2009-06-30 00:00:00 | Spring Classic |  | 69 |  | 250 | 2Q
2010-06-30 00:00:00 | Spring Classic | 70 | 34 |  | 250 | 2Q
2011-06-30 00:00:00 | Spring Classic | 40 | 62 |  | 195 | 2Q
2012-06-30 00:00:00 | Spring Classic | 75 | 83 |  | 515 | 2Q
2006-08-15 00:00:00 | Xtreme Cup |  | 188 |  |  | 3Q
2007-08-15 00:00:00 | Xtreme Cup |  |  |  |  | 3Q
2008-08-15 00:00:00 | Xtreme Cup |  | 122 |  |  | 3Q
2009-08-15 00:00:00 | Xtreme Cup |  | 105 |  | 400 | 3Q
2010-08-15 00:00:00 | Xtreme Cup | 100 | 70 |  | 350 | 3Q
2011-08-15 00:00:00 | Xtreme Cup | 90 | 75 |  | 360 | 3Q
2012-08-15 00:00:00 | Xtreme Cup | 85 | 135 |  | 360 | 3Q
2011-12-31 00:00:00 | Collegiate Showcase | 80 | 74 |  | 850 | 4Q
2013-06-30 00:00:00 | Spring Classic | 86 | 80 | 12 | 515 | 2Q
2013-07-15 00:00:00 | Sounders Cup | 45 | 24 | 6 | 495 | 3Q
2012-12-31 00:00:00 | Collegiate Showcase | 80 | 82 |  | 850 | 4Q
2013-12-31 00:00:00 | Collegiate Showcase | 20 | 20 |  | 650 | 4Q
2013-07-15 00:00:00 | Labor Day | 115 | 94 | 9 | 550 | 3Q
2013-08-15 00:00:00 | Xtreme Cup | 140 |  | 18 | 360 | 3Q
2014-06-30 00:00:00 | Spring Classic | 98 | 81 | 16 | 525 | 2Q
2014-07-15 00:00:00 | Sounders Cup | 138 | 94 | 15 | 605 | 3Q
2014-11-30 00:00:00 | Collegiate Showcase | 64 | 68 |  | 860 | 4Q
2014-07-15 00:00:00 | Labor Day | 100 | 105 | 11 | 560 | 3Q
2014-08-30 00:00:00 | Xtreme Cup | 170 | 145 |  | 370 | 3Q
2013-12-31 00:00:00 | [NAME] | 150 | 173 |  | 295 | 4Q
2013-12-31 00:00:00 | [NAME] | 52 | 45 |  | 295 | 4Q
2012-06-30 00:00:00 | Spring Classic | 20 | 42 |  | 415 | 2Q
2012-12-31 00:00:00 | Sounders Cup | 30 | 31 |  | 495 | 3Q
2012-07-15 00:00:00 | Labor Day | 110 | 115 |  | 550 | 3Q
2014-12-31 00:00:00 | Collegiate Showcase | 16 | 16 |  | 660 | 4Q
2014-07-15 00:00:00 | Labor Day | 48 | 27 | 4 | 460 | 3Q
2014-06-30 00:00:00 | Spring Classic | 50 | 31 | 4 | 425 | 2Q
2014-07-15 00:00:00 | Sounders Cup | 40 | 34 | 3 | 505 | 3Q
2013-06-30 00:00:00 | Spring Classic | 50 | 32 | 3 | 415 | 2Q
2013-07-15 00:00:00 | Sounders Cup | 132 | 87 | 13 | 595 | 3Q
2013-07-15 00:00:00 | Labor Day | 35 | 40 | 4 | 450 | 3Q
2013-12-31 00:00:00 | Collegiate Showcase | 60 | 64 |  | 850 | 4Q
2015-12-31 00:00:00 | Collegiate Showcase | 80 |  |  |  | 4Q
2015-07-15 00:00:00 | Sounders Cup | 128 |  |  |  | 3Q
2015-07-15 00:00:00 | Labor Day |  |  |  |  | 3Q
2015-07-15 00:00:00 | Labor Day |  |  |  |  | 3Q
2015-07-15 00:00:00 | Sounders Cup |  |  |  |  | 3Q
2015-08-30 00:00:00 | Xtreme Cup |  | 145 |  |  | 3Q
2015-06-30 00:00:00 | Spring Classic |  |  |  |  | 2Q