Spreadsheet: 51311d1250855529-slow-array-formulas-696558-slow-array-formulas
Sheet: Sheet1

employee | department | shift | date | Lookup
EMPLOYEE 1 | DEPARTMENT 1 |  | 2009-04-06 00:00:00 | EMPLOYEE 139909
EMPLOYEE 1 | DEPARTMENT 1 | D | 2009-04-07 00:00:00 | EMPLOYEE 139910
EMPLOYEE 1 | DEPARTMENT 1 | D | 2009-04-08 00:00:00 | EMPLOYEE 139911
EMPLOYEE 1 | DEPARTMENT 1 | D | 2009-04-09 00:00:00 | EMPLOYEE 139912
EMPLOYEE 1 | DEPARTMENT 1 |  | 2009-04-10 00:00:00 | EMPLOYEE 139913
EMPLOYEE 1 | DEPARTMENT 1 |  | 2009-04-11 00:00:00 | EMPLOYEE 139914
EMPLOYEE 1 | DEPARTMENT 1 |  | 2009-04-12 00:00:00 | EMPLOYEE 139915
EMPLOYEE 1 | DEPARTMENT 1 | A | 2009-04-13 00:00:00 | EMPLOYEE 139916
EMPLOYEE 1 | DEPARTMENT 1 | A | 2009-04-14 00:00:00 | EMPLOYEE 139917
EMPLOYEE 1 | DEPARTMENT 1 | A | 2009-04-15 00:00:00 | EMPLOYEE 139918
EMPLOYEE 1 | DEPARTMENT 1 |  | 2009-04-16 00:00:00 | EMPLOYEE 139919
EMPLOYEE 1 | DEPARTMENT 1 | D | 2009-04-17 00:00:00 | EMPLOYEE 139920
EMPLOYEE 1 | DEPARTMENT 1 | D | 2009-04-18 00:00:00 | EMPLOYEE 139921
EMPLOYEE 1 | DEPARTMENT 1 | D | 2009-04-19 00:00:00 | EMPLOYEE 139922
EMPLOYEE 1 | DEPARTMENT 1 | D | 2009-04-20 00:00:00 | EMPLOYEE 139923
EMPLOYEE 1 | DEPARTMENT 1 |  | 2009-04-21 00:00:00 | EMPLOYEE 139924
EMPLOYEE 1 | DEPARTMENT 1 |  | 2009-04-22 00:00:00 | EMPLOYEE 139925
EMPLOYEE 1 | DEPARTMENT 1 | A | 2009-04-23 00:00:00 | EMPLOYEE 139926
EMPLOYEE 1 | DEPARTMENT 1 | A | 2009-04-24 00:00:00 | EMPLOYEE 139927
EMPLOYEE 1 | DEPARTMENT 1 | A | 2009-04-25 00:00:00 | EMPLOYEE 139928
EMPLOYEE 1 | DEPARTMENT 1 | A | 2009-04-26 00:00:00 | EMPLOYEE 139929
EMPLOYEE 1 | DEPARTMENT 1 |  | 2009-04-27 00:00:00 | EMPLOYEE 139930
EMPLOYEE 1 | DEPARTMENT 1 | D | 2009-04-28 00:00:00 | EMPLOYEE 139931
EMPLOYEE 1 | DEPARTMENT 1 | D | 2009-04-29 00:00:00 | EMPLOYEE 139932
EMPLOYEE 1 | DEPARTMENT 1 | D | 2009-04-30 00:00:00 | EMPLOYEE 139933
EMPLOYEE 1 | DEPARTMENT 1 |  | 2009-05-01 00:00:00 | EMPLOYEE 139934
EMPLOYEE 1 | DEPARTMENT 1 |  | 2009-05-02 00:00:00 | EMPLOYEE 139935
EMPLOYEE 1 | DEPARTMENT 1 |  | 2009-05-03 00:00:00 | EMPLOYEE 139936
EMPLOYEE 2 | DEPARTMENT 2 | A | 2009-04-06 00:00:00 | EMPLOYEE 239909
EMPLOYEE 2 | DEPARTMENT 2 | A | 2009-04-07 00:00:00 | EMPLOYEE 239910
EMPLOYEE 2 | DEPARTMENT 2 | A | 2009-04-08 00:00:00 | EMPLOYEE 239911
EMPLOYEE 2 | DEPARTMENT 2 |  | 2009-04-09 00:00:00 | EMPLOYEE 239912
EMPLOYEE 2 | DEPARTMENT 2 | D | 2009-04-10 00:00:00 | EMPLOYEE 239913
EMPLOYEE 2 | DEPARTMENT 2 | D | 2009-04-11 00:00:00 | EMPLOYEE 239914
EMPLOYEE 2 | DEPARTMENT 2 | D | 2009-04-12 00:00:00 | EMPLOYEE 239915
EMPLOYEE 2 | DEPARTMENT 2 | D | 2009-04-13 00:00:00 | EMPLOYEE 239916
EMPLOYEE 2 | DEPARTMENT 2 |  | 2009-04-14 00:00:00 | EMPLOYEE 239917
EMPLOYEE 2 | DEPARTMENT 2 |  | 2009-04-15 00:00:00 | EMPLOYEE 239918
EMPLOYEE 2 | DEPARTMENT 2 | A | 2009-04-16 00:00:00 | EMPLOYEE 239919
EMPLOYEE 2 | DEPARTMENT 2 | A | 2009-04-17 00:00:00 | EMPLOYEE 239920
EMPLOYEE 2 | DEPARTMENT 2 | A | 2009-04-18 00:00:00 | EMPLOYEE 239921
EMPLOYEE 2 | DEPARTMENT 2 | A | 2009-04-19 00:00:00 | EMPLOYEE 239922
EMPLOYEE 2 | DEPARTMENT 2 |  | 2009-04-20 00:00:00 | EMPLOYEE 239923
EMPLOYEE 2 | DEPARTMENT 2 | D | 2009-04-21 00:00:00 | EMPLOYEE 239924
EMPLOYEE 2 | DEPARTMENT 2 | D | 2009-04-22 00:00:00 | EMPLOYEE 239925
EMPLOYEE 2 | DEPARTMENT 2 | D | 2009-04-23 00:00:00 | EMPLOYEE 239926
EMPLOYEE 2 | DEPARTMENT 2 |  | 2009-04-24 00:00:00 | EMPLOYEE 239927
EMPLOYEE 2 | DEPARTMENT 2 |  | 2009-04-25 00:00:00 | EMPLOYEE 239928
EMPLOYEE 2 | DEPARTMENT 2 |  | 2009-04-26 00:00:00 | EMPLOYEE 239929
EMPLOYEE 2 | DEPARTMENT 2 | A | 2009-04-27 00:00:00 | EMPLOYEE 239930
EMPLOYEE 2 | DEPARTMENT 2 | A | 2009-04-28 00:00:00 | EMPLOYEE 239931
EMPLOYEE 2 | DEPARTMENT 2 | A | 2009-04-29 00:00:00 | EMPLOYEE 239932
EMPLOYEE 2 | DEPARTMENT 2 |  | 2009-04-30 00:00:00 | EMPLOYEE 239933
EMPLOYEE 2 | DEPARTMENT 2 | D | 2009-05-01 00:00:00 | EMPLOYEE 239934
EMPLOYEE 2 | DEPARTMENT 2 | D | 2009-05-02 00:00:00 | EMPLOYEE 239935
EMPLOYEE 2 | DEPARTMENT 2 | D | 2009-05-03 00:00:00 | EMPLOYEE 239936
EMPLOYEE 3 | DEPARTMENT 3 |  | 2009-04-06 00:00:00 | EMPLOYEE 339909
EMPLOYEE 3 | DEPARTMENT 3 |  | 2009-04-07 00:00:00 | EMPLOYEE 339910
EMPLOYEE 3 | DEPARTMENT 3 | A | 2009-04-08 00:00:00 | EMPLOYEE 339911
EMPLOYEE 3 | DEPARTMENT 3 | A | 2009-04-09 00:00:00 | EMPLOYEE 339912
EMPLOYEE 3 | DEPARTMENT 3 | A | 2009-04-10 00:00:00 | EMPLOYEE 339913
EMPLOYEE 3 | DEPARTMENT 3 | A | 2009-04-11 00:00:00 | EMPLOYEE 339914
EMPLOYEE 3 | DEPARTMENT 3 | A | 2009-04-12 00:00:00 | EMPLOYEE 339915
EMPLOYEE 3 | DEPARTMENT 3 |  | 2009-04-13 00:00:00 | EMPLOYEE 339916
EMPLOYEE 3 | DEPARTMENT 3 |  | 2009-04-14 00:00:00 | EMPLOYEE 339917
EMPLOYEE 3 | DEPARTMENT 3 | D | 2009-04-15 00:00:00 | EMPLOYEE 339918
EMPLOYEE 3 | DEPARTMENT 3 | D | 2009-04-16 00:00:00 | EMPLOYEE 339919
EMPLOYEE 3 | DEPARTMENT 3 | D | 2009-04-17 00:00:00 | EMPLOYEE 339920
EMPLOYEE 3 | DEPARTMENT 3 | D | 2009-04-18 00:00:00 | EMPLOYEE 339921
EMPLOYEE 3 | DEPARTMENT 3 |  | 2009-04-19 00:00:00 | EMPLOYEE 339922
EMPLOYEE 3 | DEPARTMENT 3 | A | 2009-04-20 00:00:00 | EMPLOYEE 339923
EMPLOYEE 3 | DEPARTMENT 3 | A | 2009-04-21 00:00:00 | EMPLOYEE 339924
EMPLOYEE 3 | DEPARTMENT 3 | A | 2009-04-22 00:00:00 | EMPLOYEE 339925
EMPLOYEE 3 | DEPARTMENT 3 | A | 2009-04-23 00:00:00 | EMPLOYEE 339926
EMPLOYEE 3 | DEPARTMENT 3 | A | 2009-04-24 00:00:00 | EMPLOYEE 339927
EMPLOYEE 3 | DEPARTMENT 3 |  | 2009-04-25 00:00:00 | EMPLOYEE 339928
EMPLOYEE 3 | DEPARTMENT 3 |  | 2009-04-26 00:00:00 | EMPLOYEE 339929
EMPLOYEE 3 | DEPARTMENT 3 | N | 2009-04-27 00:00:00 | EMPLOYEE 339930
EMPLOYEE 3 | DEPARTMENT 3 | N | 2009-04-28 00:00:00 | EMPLOYEE 339931
EMPLOYEE 3 | DEPARTMENT 3 | N | 2009-04-29 00:00:00 | EMPLOYEE 339932
EMPLOYEE 3 | DEPARTMENT 3 |  | 2009-04-30 00:00:00 | EMPLOYEE 339933
EMPLOYEE 3 | DEPARTMENT 3 |  | 2009-05-01 00:00:00 | EMPLOYEE 339934
EMPLOYEE 3 | DEPARTMENT 3 | D | 2009-05-02 00:00:00 | EMPLOYEE 339935
EMPLOYEE 3 | DEPARTMENT 3 | D | 2009-05-03 00:00:00 | EMPLOYEE 339936