Spreadsheet: 170592d1343326142-index-match-if-formula-need-help-excelforum_help
Sheet: master

 | NAME |  |  |  |  |  |  |  |  |  | NAME
 | B.U. | Activity | LCFC | Series | Model | Product | Status | Start | Finish |  | Business Unit | Activity | LCFC | Series | Model | Product | Status | Start | Finish
 | abc | jar2 |  | v | 123 |  |  | 2012-04-16 00:00:00 | 2012-04-26 00:00:00 |  | abc | jar | Yes | v | 123 |  | UpComing | 2012-07-18 00:00:00 | 2012-07-25 00:00:00
 | abc | jar3 |  | z | 123 |  |  | 2012-04-16 00:00:00 | 2012-04-26 00:00:00 |  | abc | jar | Yes | x | 123 |  | UpComing | 2012-07-18 00:00:00 | 2012-07-25 00:00:00
 | abc | jar2 |  | x | 123 |  |  | 2012-05-14 00:00:00 | 2012-05-24 00:00:00 |  | abc | jar | Yes | z | 123 |  | UpComing | 2012-07-18 00:00:00 | 2012-07-25 00:00:00
 | abc | jar3 |  | v | 123 |  |  | 2012-05-14 00:00:00 | 2012-05-24 00:00:00 |  | abc | jar2 |  | v | 123 |  | on Hold | 2012-03-31 00:00:00 | 2012-04-13 00:00:00
 | abc | jar2 |  | z | 123 |  |  | 2012-05-31 00:00:00 | 2012-06-12 00:00:00 |  | abc | jar3 |  | x | 123 |  | on Hold | 2012-03-31 00:00:00 | 2012-04-13 00:00:00
 | abc | jar3 |  | x | 123 |  |  | 2012-05-31 00:00:00 | 2012-06-12 00:00:00 |  | abc | jar2 |  | z | 123 |  | UpComing | 2012-07-26 00:00:00 | 2012-08-06 00:00:00
 | abc | jar4 |  | v | 123 |  |  | 2012-04-27 00:00:00 | 2012-05-04 00:00:00 |  | abc | jar3 |  | v | 123 |  | UpComing | 2012-07-26 00:00:00 | 2012-08-06 00:00:00
 | abc | [NAME] |  | z | 123 |  |  | 2012-04-27 00:00:00 | 2012-05-04 00:00:00 |  | abc | jar2 |  | x | 123 |  | UpComing | 2012-08-23 00:00:00 | 2012-09-04 00:00:00
 | abc | jar4 |  | x | 123 |  |  | 2012-06-13 00:00:00 | 2012-06-26 00:00:00 |  | abc | jar3 |  | z | 123 |  | UpComing | 2012-08-23 00:00:00 | 2012-09-04 00:00:00
 | abc | [NAME] |  | v | 123 |  |  | 2012-06-13 00:00:00 | 2012-06-26 00:00:00 |  | abc | jar2 |  | v | 123 |  | UpComing | 2012-09-05 00:00:00 | 2012-09-17 00:00:00
 | abc | jarb |  | z | 123 |  |  | 2012-05-07 00:00:00 | 2012-05-11 00:00:00 |  | abc | jar3 |  | x | 123 |  | UpComing | 2012-09-05 00:00:00 | 2012-09-17 00:00:00
 | abc | SP |  | x | 123 |  |  | 2012-05-28 00:00:00 | 2012-05-30 00:00:00 |  | abc | jar2 |  | z | 123 |  | UpComing | 2012-09-18 00:00:00 | 2012-09-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  | abc | jar3 |  | v | 123 |  | UpComing | 2012-09-18 00:00:00 | 2012-09-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  | abc | jar4 |  | x | 123 |  | UpComing | 2012-08-08 00:00:00 | 2012-08-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  | abc | [NAME] |  | z | 123 |  | UpComing | 2012-08-08 00:00:00 | 2012-08-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  | abc | jar4 |  | v | 123 |  | UpComing | 2012-10-09 00:00:00 | 2012-10-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  | abc | [NAME] |  | x | 123 |  | UpComing | 2012-10-09 00:00:00 | 2012-10-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  | abc | jarb |  | z | 123 |  | Completed | 2012-06-27 00:00:00 | 2012-07-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  | abc | jarb |  | v | 123 |  | UpComing | 2012-08-16 00:00:00 | 2012-08-22 00:00:00
 |  |  |  |  |  |  |  |  |  |  | abc | jarb |  | x | 123 |  | UpComing | 2012-10-16 00:00:00 | 2012-10-22 00:00:00
 |  |  |  |  |  |  |  |  |  |  | abc | SP |  | z | 123 |  | Completed | 2012-07-05 00:00:00 | 2012-07-09 00:00:00