Spreadsheet: 219958d1363022797-looking-up-a-value-based-on-two-pieces-of-information-test9
Sheet: Rota

Name | Pattern | Date | Rota
[NAME] | 2 | 2013-03-01 00:00:00
[NAME] | 2 | 2013-03-02 00:00:00
[NAME] | 2 | 2013-03-03 00:00:00
[NAME] | 2 | 2013-03-04 00:00:00
[NAME] | 2 | 2013-03-05 00:00:00
[NAME] | 2 | 2013-03-06 00:00:00
[NAME] | 2 | 2013-03-07 00:00:00
[NAME] | 2 | 2013-03-08 00:00:00
[NAME] | 2 | 2013-03-09 00:00:00
[NAME] | 2 | 2013-03-10 00:00:00
[NAME] | 2 | 2013-03-11 00:00:00
[NAME] | 2 | 2013-03-12 00:00:00
[NAME] | 2 | 2013-03-13 00:00:00
[NAME] | 2 | 2013-03-14 00:00:00
[NAME] | 2 | 2013-03-15 00:00:00
[NAME] | 2 | 2013-03-16 00:00:00
[NAME] | 2 | 2013-03-17 00:00:00
[NAME] | 2 | 2013-03-18 00:00:00
[NAME] | 2 | 2013-03-19 00:00:00
[NAME] | 2 | 2013-03-20 00:00:00
[NAME] | 2 | 2013-03-21 00:00:00
[NAME] | 2 | 2013-03-22 00:00:00
[NAME] | 2 | 2013-03-23 00:00:00
[NAME] | 2 | 2013-03-24 00:00:00
[NAME] | 2 | 2013-03-25 00:00:00
[NAME] | 2 | 2013-03-26 00:00:00
[NAME] | 2 | 2013-03-27 00:00:00
[NAME] | 2 | 2013-03-28 00:00:00
[NAME] | 2 | 2013-03-29 00:00:00
[NAME] | 2 | 2013-03-30 00:00:00
[NAME] | 2 | 2013-03-31 00:00:00
[NAME] | 1 | 2013-03-01 00:00:00
[NAME] | 1 | 2013-03-02 00:00:00
[NAME] | 1 | 2013-03-03 00:00:00
[NAME] | 1 | 2013-03-04 00:00:00
[NAME] | 1 | 2013-03-05 00:00:00
[NAME] | 1 | 2013-03-06 00:00:00
[NAME] | 1 | 2013-03-07 00:00:00
[NAME] | 1 | 2013-03-08 00:00:00
[NAME] | 1 | 2013-03-09 00:00:00
[NAME] | 1 | 2013-03-10 00:00:00
[NAME] | 1 | 2013-03-11 00:00:00
[NAME] | 1 | 2013-03-12 00:00:00
[NAME] | 1 | 2013-03-13 00:00:00
[NAME] | 1 | 2013-03-14 00:00:00
[NAME] | 1 | 2013-03-15 00:00:00
[NAME] | 1 | 2013-03-16 00:00:00
[NAME] | 1 | 2013-03-17 00:00:00
[NAME] | 1 | 2013-03-18 00:00:00
[NAME] | 1 | 2013-03-19 00:00:00
[NAME] | 1 | 2013-03-20 00:00:00
[NAME] | 1 | 2013-03-21 00:00:00
[NAME] | 1 | 2013-03-22 00:00:00
[NAME] | 1 | 2013-03-23 00:00:00
[NAME] | 1 | 2013-03-24 00:00:00
[NAME] | 1 | 2013-03-25 00:00:00
[NAME] | 1 | 2013-03-26 00:00:00
[NAME] | 1 | 2013-03-27 00:00:00
[NAME] | 1 | 2013-03-28 00:00:00
[NAME] | 1 | 2013-03-29 00:00:00
[NAME] | 1 | 2013-03-30 00:00:00
[NAME] | 1 | 2013-03-31 00:00:00
[NAME] | 3 | 2013-03-01 00:00:00
[NAME] | 3 | 2013-03-02 00:00:00
[NAME] | 3 | 2013-03-03 00:00:00
[NAME] | 3 | 2013-03-04 00:00:00
[NAME] | 3 | 2013-03-05 00:00:00
[NAME] | 3 | 2013-03-06 00:00:00
[NAME] | 3 | 2013-03-07 00:00:00
[NAME] | 3 | 2013-03-08 00:00:00
[NAME] | 3 | 2013-03-09 00:00:00
[NAME] | 3 | 2013-03-10 00:00:00
[NAME] | 3 | 2013-03-11 00:00:00
[NAME] | 3 | 2013-03-12 00:00:00
[NAME] | 3 | 2013-03-13 00:00:00
[NAME] | 3 | 2013-03-14 00:00:00
[NAME] | 3 | 2013-03-15 00:00:00
[NAME] | 3 | 2013-03-16 00:00:00
[NAME] | 3 | 2013-03-17 00:00:00
[NAME] | 3 | 2013-03-18 00:00:00
[NAME] | 3 | 2013-03-19 00:00:00
[NAME] | 3 | 2013-03-20 00:00:00
[NAME] | 3 | 2013-03-21 00:00:00
[NAME] | 3 | 2013-03-22 00:00:00
[NAME] | 3 | 2013-03-23 00:00:00
[NAME] | 3 | 2013-03-24 00:00:00
[NAME] | 3 | 2013-03-25 00:00:00
[NAME] | 3 | 2013-03-26 00:00:00
[NAME] | 3 | 2013-03-27 00:00:00
[NAME] | 3 | 2013-03-28 00:00:00
[NAME] | 3 | 2013-03-29 00:00:00
[NAME] | 3 | 2013-03-30 00:00:00
[NAME] | 3 | 2013-03-31 00:00:00