Spreadsheet: 60605d1261114469-extracting-data-using-index-or-match-sample
Sheet: Sheet1

 |  |  |  |  | 1 |  |  |  |  | 2 |  |  |  |  | 3 |  |  |  |  | 4 |  |  |  |  | 5 |  |  |  |  | 6
 | Teams |  |  | DB | BJ | AD |  |  | DH | JK | BI |  |  | IB | ML | LD |  |  | GG | IW | AM |  |  | AB | CB | JM |  |  | MG | PC | PB |  |  |  | M | A | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I'm in need of a formula (match and/or index?) that can create
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | the expected entries as shown in Cols AJ - AL.   These have
 |  |  | 2010-01-04 00:00:00 | O | O | A |  |  | A | A | A |  |  | O | O | O |  |  | M | M | M |  |  | O | O | O |  |  | N | N | N |  | 2010-01-04 00:00:00 |  | IW | JK | JK |  | been derived from Cols E - AF.  ie the "IW" in AJ10 comes
 |  |  | 2010-01-05 00:00:00 | O | O | O |  |  | A | A | A |  |  | O | O | O |  |  | M | M | M |  |  | O | O | O |  |  | N | N | N |  | 2010-01-05 00:00:00 |  | IW | JK | JK |  | from the fact there is a "M" below "IW" in [NAME].
 |  |  | 2010-01-06 00:00:00 | O | O | O |  |  | M | M | M |  |  | O | O | O |  |  | N | N | N |  |  | A | A | A |  |  | O | O | O |  | 2010-01-06 00:00:00 |  | JK | CB | CB
 |  |  | 2010-01-07 00:00:00 | O | O | O |  |  | M | M | M |  |  | O | O | O |  |  | N | N | N |  |  | A | A | A |  |  | O | O | O |  | 2010-01-07 00:00:00 |  | JK | CB | CB
 |  |  | 2010-01-08 00:00:00 | O | O | O |  |  | N | N | N |  |  | A | A | A |  |  | O | O | O |  |  | M | M | M |  |  | O | O | O |  | 2010-01-08 00:00:00 |  | CB | ML | ML
 |  |  | 2010-01-09 00:00:00 | O | O | O |  |  | N | N | N |  |  | A | A | A |  |  | O | O | O |  |  | M | M | M |  |  | O | O | O |  | 2010-01-09 00:00:00 |  | CB | ML | ML
 |  |  | 2010-01-10 00:00:00 | O | O | O |  |  | N | N | N |  |  | A | A | A |  |  | O | O | O |  |  | M | M | M |  |  | O | O | O |  | 2010-01-10 00:00:00 |  | CB | ML | ML |  | Note the change in team member resulting in groupings of
 |  |  | 2010-01-11 00:00:00 | A | A | A |  |  | O | O | O |  |  | M | M | M |  |  | O | O | O |  |  | N | N | N |  |  | O | O | O |  | 2010-01-11 00:00:00 |  | LD | AD | AD |  | orange blue or green men
 |  |  | 2010-01-12 00:00:00 | A | A | A |  |  | O | O | O |  |  | M | M | M |  |  | O | O | O |  |  | N | N | N |  |  | O | O | O |  | 2010-01-12 00:00:00 |  | LD | AD | AD
 |  |  | 2010-01-13 00:00:00 | M | M | M |  |  | O | O | O |  |  | N | N | N |  |  | A | A | A |  |  | O | O | O |  |  | O | O | O |  | 2010-01-13 00:00:00 |  | AD | AM | AM
 |  |  | 2010-01-14 00:00:00 | M | M | M |  |  | O | O | O |  |  | N | N | N |  |  | A | A | A |  |  | O | O | O |  |  | O | O | O |  | 2010-01-14 00:00:00 |  | AD | AM | AM
 |  |  | 2010-01-15 00:00:00 | N | N | N |  |  | A | A | A |  |  | O | O | O |  |  | M | M | M |  |  | O | O | O |  |  | O | O | O |  | 2010-01-15 00:00:00 |  | AM | BI | BI
 |  |  | 2010-01-16 00:00:00 | N | N | N |  |  | A | A | A |  |  | O | O | O |  |  | M | M | M |  |  | O | O | O |  |  | O | O | O |  | 2010-01-16 00:00:00 |  | AM | BI | BI
 |  |  | 2010-01-17 00:00:00 | N | N | N |  |  | A | A | A |  |  | O | O | O |  |  | M | M | M |  |  | O | O | O |  |  | O | O | O |  | 2010-01-17 00:00:00 |  | AM | BI | BI
 |  |  | 2010-01-18 00:00:00 | O | O | O |  |  | M | M | M |  |  | O | O | O |  |  | N | N | N |  |  | O | O | O |  |  | A | A | A |  | 2010-01-18 00:00:00 |  | DH | MG | MG
 |  |  | 2010-01-19 00:00:00 | O | O | O |  |  | M | M | M |  |  | O | O | O |  |  | N | N | N |  |  | O | O | O |  |  | A | A | A |  | 2010-01-19 00:00:00 |  | DH | MG | MG
 |  |  | 2010-01-20 00:00:00 | O | O | O |  |  | N | N | N |  |  | A | A | A |  |  | O | O | O |  |  | O | O | O |  |  | M | M | M |  | 2010-01-20 00:00:00 |  | MG | IB | IB
 |  |  | 2010-01-21 00:00:00 | O | O | O |  |  | N | N | N |  |  | A | A | A |  |  | O | O | O |  |  | O | O | O |  |  | M | M | M |  | 2010-01-21 00:00:00 |  | MG | IB | IB
 |  |  | 2010-01-22 00:00:00 | A | A | A |  |  | O | O | O |  |  | M | M | M |  |  | O | O | O |  |  | O | O | O |  |  | N | N | N |  | 2010-01-22 00:00:00 |  | IB | DB | DB
 |  |  | 2010-01-23 00:00:00 | A | A | A |  |  | O | O | O |  |  | M | M | M |  |  | O | O | O |  |  | O | O | O |  |  | N | N | N |  | 2010-01-23 00:00:00 |  | IB | DB | DB
 |  |  | 2010-01-24 00:00:00 | A | A | A |  |  | O | O | O |  |  | M | M | M |  |  | O | O | O |  |  | O | O | O |  |  | N | N | N |  | 2010-01-24 00:00:00 |  | IB | DB | DB
 |  |  | THROUGH
 |  |  | 2009-12-31 00:00:00