Spreadsheet: 269612d1381231340-lookup-two-criteria-and-return-a-third-criteria-as-result-aaaargh-test_tracker_example
Sheet: Example

 | DATE | DAY | APS | WA | NSW | VIC | QLD | SA | ACT
 | 2013-09-16 00:00:00 | Mon
 | 2013-09-17 00:00:00 | [NAME] | Unavailable | Unavailable
 | 2013-09-18 00:00:00 | Wed |  |  | Unavailable | Unavailable |  |  |  |  |  | SHOULD END UP LIKE THIS (formula results in RED)
 | 2013-09-19 00:00:00 | Thurs |  |  |  |  | Unavailable | Unavailable | Unavailable |  |  | DATE | DAY | APS | WA | NSW | VIC | QLD | SA | ACT
 | 2013-09-20 00:00:00 | Fri | Unavailable |  |  |  |  |  |  |  |  | 2013-09-16 00:00:00 | Mon
 | 2013-09-21 00:00:00 | Sat |  |  |  |  |  |  |  |  |  | 2013-09-17 00:00:00 | [NAME] | Unavailable | Unavailable
 | 2013-09-22 00:00:00 | Sun |  |  |  |  |  |  |  |  |  | 2013-09-18 00:00:00 | Wed |  |  | Unavailable | Unavailable
 | 2013-09-23 00:00:00 | Mon |  |  |  |  |  |  |  |  |  | 2013-09-19 00:00:00 | Thurs |  |  |  |  | Unavailable | Unavailable | Unavailable
 | 2013-09-24 00:00:00 | [NAME] | Unavailable | Unavailable |  |  |  |  |  |  |  | 2013-09-20 00:00:00 | Fri | Unavailable
 | 2013-09-25 00:00:00 | Wed |  |  | Unavailable | Unavailable |  |  |  |  |  | 2013-09-21 00:00:00 | Sat
 | 2013-09-26 00:00:00 | Thurs |  |  |  |  | Unavailable | Unavailable | Unavailable |  |  | 2013-09-22 00:00:00 | Sun
 | 2013-09-27 00:00:00 | Fri | Unavailable |  |  |  |  |  |  |  |  | 2013-09-23 00:00:00 | Mon
 | 2013-09-28 00:00:00 | Sat |  |  |  |  |  |  |  |  |  | 2013-09-24 00:00:00 | [NAME] | Unavailable | Unavailable
 | 2013-09-29 00:00:00 | Sun |  |  |  |  |  |  |  |  |  | 2013-09-25 00:00:00 | Wed |  |  | Unavailable | Unavailable
 | 2013-09-30 00:00:00 | Mon |  |  |  |  |  |  |  |  |  | 2013-09-26 00:00:00 | Thurs |  |  |  |  | Unavailable | Unavailable | Unavailable
 | 2013-10-01 00:00:00 | [NAME] | Unavailable | Unavailable |  |  |  |  |  |  |  | 2013-09-27 00:00:00 | Fri | Unavailable
 | 2013-10-02 00:00:00 | Wed |  |  | Unavailable | Unavailable |  |  |  |  |  | 2013-09-28 00:00:00 | Sat
 | 2013-10-03 00:00:00 | Thurs |  |  |  |  | Unavailable | Unavailable | Unavailable |  |  | 2013-09-29 00:00:00 | Sun
 | 2013-10-04 00:00:00 | Fri | Unavailable |  |  |  |  |  |  |  |  | 2013-09-30 00:00:00 | Mon
 | 2013-10-05 00:00:00 | Sat |  |  |  |  |  |  |  |  |  | 2013-10-01 00:00:00 | [NAME] | Unavailable | Unavailable
 | 2013-10-06 00:00:00 | Sun |  |  |  |  |  |  |  |  |  | 2013-10-02 00:00:00 | Wed |  |  | Unavailable | Unavailable
 |  |  |  |  |  |  |  |  |  |  |  | 2013-10-03 00:00:00 | Thurs |  |  |  |  | Unavailable | Unavailable | Unavailable
 |  |  |  |  |  |  |  |  |  |  |  | 2013-10-04 00:00:00 | Fri
 |  |  |  |  |  |  |  |  |  |  |  | 2013-10-05 00:00:00 | Sat
 | Client | State | Contract No. | Date |  |  |  |  |  |  |  | 2013-10-06 00:00:00 | Sun
 | Client 1 | APS | 12176 | 2013-09-30 00:00:00
 | Client 2 | QLD | 11620 | 2013-09-30 00:00:00
 | Client 3 | ACT | 12174 | 2013-10-02 00:00:00
 | Client 4 | ACT | 12100 | 2013-10-01 00:00:00
 | Client 5 | Vic | 12166 | 2013-10-01 00:00:00
 | Client 6 | SA | 12168 | 2013-09-24 00:00:00
 | Client 7 | Vic | 12177 | 2013-09-23 00:00:00
 | Client 8 | SA | 12106 | 2013-09-17 00:00:00