I need to pull the value ( name ) from Column "O" when the game matches another it's self.
Criteria 1 Same date is found
Criteria 2 Team in Column D is found in Coulumn C
In the case highlighted in RED
Q9 should have CHIWhiteSoxBuehrle
Q14 should have KCRoyalsHrnndz
Since I have 5000 games total I need a forumula to read the array's and
pull the data when the two criteria are true?
Any ideas?
Criteria 1 Same date is found
Criteria 2 Team in Column D is found in Coulumn C
In the case highlighted in RED
Q9 should have CHIWhiteSoxBuehrle
Q14 should have KCRoyalsHrnndz
Since I have 5000 games total I need a forumula to read the array's and
pull the data when the two criteria are true?
Any ideas?
mlb sched.xls | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | Date | Site | TEAM | OPPONENT | Starter | OppStarter | OPPPitch | Hand | Pitch | |||
2 | 03/31/03 | Away | BOSRedSox | TAMDevilRays | Martinz | Kennedy | TAMDevilRaysKennedy | L | ||||
3 | 03/31/03 | Away | CHICubs | NYMets | Wood | Glavine | NYMetsGlavine | L | ||||
4 | 03/31/03 | Away | CHIWhiteSox | KCRoyals | Buehrle | Hrnndz | KCRoyalsHrnndz | R | ||||
5 | 03/31/03 | Home | CINReds | PITPirates | Haynes | Benson | PITPiratesBenson | R | ||||
6 | 03/31/03 | Home | FLAMarlins | PHIPhillies | Beckett | Milwood | PHIPhilliesMilwood | R | ||||
7 | 03/31/03 | Home | KCRoyals | CHIWhiteSox | Hrnndz | Buehrle | CHIWhiteSoxBuehrle | L | ||||
8 | 03/31/03 | Away | LADodgers | ARID'backs | Nomo | RJhnsn | ARID'backsRJhnsn | L | ||||
9 | 04/01/03 | Away | COLRockies | HOUAstros | Jennigs | Oswalt | HOUAstrosOswalt | R | ||||
10 | 04/01/03 | Home | HOUAstros | COLRockies | Oswalt | Jennigs | COLRockiesJennigs | R | ||||
11 | 04/01/03 | Away | LADodgers | ARID'backs | Perez | Schilng | ARID'backsSchilng | R | ||||
12 | 04/01/03 | Away | NYYankees | TORBlueJays | Pettite | Lidle | TORBlueJaysLidle | R | ||||
13 | 04/01/03 | Home | OAKAthletics | SEAMariners | Hudson | Garcia | SEAMarinersGarcia | R | ||||
14 | 04/01/03 | Home | SDGPadres | SFGiants | Eaton | Schmidt | SFGiantsSchmidt | R | ||||
15 | 04/01/03 | Away | SEAMariners | OAKAthletics | Garcia | Hudson | OAKAthleticsHudson | R | ||||
16 | 04/01/03 | Away | SFGiants | SDGPadres | Schmidt | Eaton | SDGPadresEaton | R | ||||
Sheet1 |