Spreadsheet: 80262d1280438142-lookup-or-match-index-archery5
Sheet: Input sheet

 | Bow | Category | Round | Score |  | Classification |  | F-Row | L-Row | Col | Match
 | Compound | Gentlemen | York | 890 |  | 2nd Class |  | 80 | 85 | 4 | 5
 | Compound | Gentlemen | York | 300 |  | 3rd Class |  | <<< [NAME] and select the first 4 values.  See the UDF in cell G8
 |  |  |  |  |  |  |  | <<< This called a User Defined Function and will work with your Classifications 2010 sheet.
 | Archery classifications explained.
 | Every time you shoot one of the 59 rounds (which vary in the numbers of arrows, distance, and target size) in addition to a handicap score you earn a classification. They Range from Grand Master Bowman (GMB) to unclassified. You need to achieve or exceed a particular score to get the respective classification.  Some rounds are less demanding and the higher classification cannot be earned by shooting them.  There are 40 Categories of archer depending on age, gender and bow type with varying ‘thresholds’ for the awards.
 | In the table for example looking at the recurve gents ‘Hereford Round’ |  |  |  |  |  |  | Score | Clasification
 |  |  |  |  |  |  |  | 900 | 1st class |  | Bows | Categories |  | Ladies |  | Round
 |  |  |  |  |  |  |  | 883 | 2nd class |  | Recurve Compound | Ladies |  | J Ladies U-18 |  | York
 |  |  |  |  |  |  |  |  |  |  | Compound | J Ladies U-18 |  | J Ladies U-19 |  | [NAME] or Bristol
 |  |  |  |  |  |  |  |  |  |  | [NAME] | J Ladies U-19 |  | J Ladies U-20 |  | Bristol  ll
 |  |  |  |  |  |  |  |  |  |  | Barebow | J Ladies U-20 |  | J Ladies U-21 |  | Bristol lll
 |  |  |  |  |  |  |  |  |  |  |  | J Ladies U-21 |  | J Ladies U-22 |  | Bristol lV
 |  |  |  |  |  |  |  |  |  |  |  | J Ladies U-22 |  | J Ladies U-16 |  | Bristol V
 |  |  |  |  |  |  |  |  |  |  |  | J Ladies U-16 |  | J Ladies U-17 |  | St. George
 |  |  |  |  |  |  |  |  |  |  |  | J Ladies U-17 |  | J Ladies U-11 |  | Albion
 |  |  |  |  |  |  |  |  |  |  |  | J Ladies U-11 |  | J Ladies U-12 |  | Windsor
 |  |  |  |  |  |  |  |  |  |  |  | J Ladies U-12 |  | J Ladies U-13 |  | Short Windsor
 |  |  |  |  |  |  |  |  |  |  |  | J Ladies U-13 |  | J Ladies U-14 |  | Junior Windsor
 |  |  |  |  |  |  |  |  |  |  |  | J Ladies U-14 |  | J Ladies U-15 |  | Short Junior Windsor
 |  |  |  |  |  |  |  |  |  |  |  | J Ladies U-15 |  | Gentlemen |  | New Western
 |  |  |  |  |  |  |  |  |  |  |  | Gentlemen |  | J Gents U-18 |  | Long Western
 |  |  |  |  |  |  |  |  |  |  |  | J Gents U-18 |  | J Gents U-19 |  | Western
 |  |  |  |  |  |  |  |  |  |  |  | J Gents U-19 |  | J Gents U-20 |  | Short Western
 |  |  |  |  |  |  |  |  |  |  |  | J Gents U-20 |  | J Gents U-21 |  | Junior Western
 |  |  |  |  |  |  |  |  |  |  |  | J Gents U-21 |  | J Gents U-22 |  | Short Junior Western
 |  |  |  |  |  |  |  |  |  |  |  | J Gents U-22 |  | J Gents U-16 |  | American
 |  |  |  |  |  |  |  |  |  |  |  | J Gents U-16 |  | J Gents U-17 |  | St. [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | J Gents U-17 |  | J Gents U-14 |  | New National
 |  |  |  |  |  |  |  |  |  |  |  | J Gents U-14 |  | J Gents U-15 |  | Long National
 |  |  |  |  |  |  |  |  |  |  |  | J Gents U-15 |  | J Gents U-12 |  | National
 |  |  |  |  |  |  |  |  |  |  |  | J Gents U-12 |  | J Gents U-13 |  | Short National
 |  |  |  |  |  |  |  |  |  |  |  | J Gents U-13 |  |  |  | Junior National
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Short Junior National
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New Warwick
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Warwick
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Short Warwick
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Junior Warwick
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Short Junior Warwick
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Metric l
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Metric ll
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Metric lll
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Metric lV
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Metric V
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Half Metric 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Short Metric II
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] lll
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] lV
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Long Metric I
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ll
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] lll
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] lV
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Long MetricV
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Short Metric I
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Short Metric Il
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Short Metric Ill
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Short Metric V
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FITA Gents
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FITA Ladies
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FITA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FITA 70m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FITA 60m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Long Metric Ladies
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Short Metric
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Half FITA Gents
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Half FITA Ladies
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bow Round