Spreadsheet: 60622d1261127659-extracting-data-using-index-or-match-ready-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 | O
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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 |  |  |  |  |  |  |  |  |  |  |  | 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 |  |  |  |  |  |  |  |  |  |  |  | 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
 |  | 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
 |  | 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
 |  | 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
 |  | 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 |  |  |  |  |  |  |  |  |  |  |  | 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 |  |  |  |  |  |  |  |  |  |  |  | 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
 |  | 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
 |  | 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
 |  | 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
 |  | 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
 |  | 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
 |  | 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
 |  | 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
 |  | 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
 |  | 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
 |  | 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
 |  | 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
 |  | 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