Spreadsheet: 99014d1297800584-multiple-lookups-example
Sheet: Sheet1

 |  |  | JANUARY
 |  | S
MECHANICS |  | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 | 2011-01-08 00:00:00 | 2011-01-09 00:00:00 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00 | 2011-01-12 00:00:00 | 2011-01-13 00:00:00 | 2011-01-14 00:00:00 | 2011-01-15 00:00:00 | 2011-01-16 00:00:00 | 2011-01-17 00:00:00 | 2011-01-18 00:00:00 | 2011-01-19 00:00:00 | 2011-01-20 00:00:00 | 2011-01-21 00:00:00 | 2011-01-22 00:00:00 | 2011-01-23 00:00:00 | 2011-01-24 00:00:00 | 2011-01-25 00:00:00 | 2011-01-26 00:00:00 | 2011-01-27 00:00:00 | 2011-01-28 00:00:00 | 2011-01-29 00:00:00 | 2011-01-30 00:00:00 | 2011-01-31 00:00:00
POS | NAME | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M
1 | Person 1 | O | O |  |  |  |  |  | O | O |  |  |  |  |  | O | O |  |  |  |  | M | O | O |  |  |  |  |  | O | O
2 | Person 2 | O | O |  |  |  |  | M | O | O |  |  |  |  |  | O | O |  |  |  |  |  | O | O |  |  |  |  | M | O | O
3 | Person 3 |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O
4 | Person 4 |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O
5 | Person 5 |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O
6 | Person 6 |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O
7 | Person 7 |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O
8 | Person 8 | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O
9 | Person 9 | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O
10 | Person 10 | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O
11 | Person 11 | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O
12 | Person 12 | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  | O | O | O | O
13 | Person 13 |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O
14 | Person 14 |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O
15 | Person 15 |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O
16 | Person 16 |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O
17 | Person 17 | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O
18 | Person 18 | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O
19 | Person 19 | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O
20 | Person 20 | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O
21 | Person 21 | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O |  |  |  |  | O | O | O
 | Day Shift | 5 | 4 | 6 | 6 | 6 | 5 | 6 | 4 | 4 | 8 | 5 | 6 | 6 | 7 | 4 | 4 | 8 | 6 | 6 | 4 | 6 | 4 | 4 | 8 | 3 | 3 | 3 | 2 | 3 | 3 | 6
 | [NAME] | 4 | 4 | 4 | 3 | 3 | 3 | 5 | 4 | 4 | 6 | 2 | 3 | 3 | 4 | 3 | 4 | 6 | 3 | 2 | 3 | 4 | 4 | 4 | 6 | 3 | 3 | 3 | 4 | 3 | 3 | 5