Spreadsheet: 689350d1596321944-how-to-reference-data-based-on-formula-result-sample
Sheet: Core_Dataset

EmpID | Worker Name | DOB | DateofHire | Position | Department | EmpStatus | TermType | DateofTermination
3 |  |  | 2004-04-01 00:00:00 |  |  | Active
6 |  |  | 2004-04-01 00:00:00 |  | Product Management | Active
7 |  |  | 2005-08-15 00:00:00 |  | Strategic Planning & PMO | Active
9 |  |  | 2005-09-25 00:00:00 |  | Compliance Management | Active
10 |  |  | 2006-05-20 00:00:00 |  |  | Active
11 |  |  | 2006-05-20 00:00:00 |  | Information Technology | Active
14 |  |  | 2007-03-17 00:00:00 |  | Shared Services | Active
15 |  |  | 2007-04-28 00:00:00 |  | Product Management | Active
17 |  |  | 2007-11-10 00:00:00 |  | Product Management | Active
18 |  |  | 2008-03-15 00:00:00 |  | Shared Services | Active
20 |  |  | 2008-04-15 00:00:00 |  | Communication & Marketing | Active
22 |  |  | 2008-08-10 00:00:00 |  | Shared Services | Active
23 |  |  | 2008-08-10 00:00:00 |  | CEO Office | Active
30 |  |  | 2009-05-16 00:00:00 |  | Product Management | Active
32 |  |  | 2009-06-01 00:00:00 |  | Data Management | Active
34 |  |  | 2009-06-01 00:00:00 |  | Compliance Management | Term | Resigned | 2020-02-08 00:00:00
37 |  |  | 2009-09-02 00:00:00 |  | Information Technology | Term | Resigned | 2020-06-11 00:00:00
42 |  |  | 2010-03-02 00:00:00 |  | Shared Services | Active
47 |  |  | 2010-05-01 00:00:00 |  | Data Management | Active
49 |  |  | 2010-05-08 00:00:00 |  | Business Development | Active
52 |  |  | 2010-07-17 00:00:00 |  | Compliance Management | Active
55 |  |  | 2010-10-09 00:00:00 |  |  | Active
60 |  |  | 2010-11-06 00:00:00 |  | Shared Services | Active
61 |  |  | 2010-11-06 00:00:00 |  |  | Active
66 |  |  | 2011-08-13 00:00:00 |  | Data Management | Active
73 |  |  | 2011-12-19 00:00:00 |  | Communication & Marketing | Active
76 |  |  | 2012-01-02 00:00:00 |  | Data Management | Active
87 |  |  | 2012-04-01 00:00:00 |  | Information Technology | Active
92 |  |  | 2012-05-12 00:00:00 |  | Communication & Marketing | Active
104 |  |  | 2013-01-05 00:00:00 |  | Business Development | Active
109 |  |  | 2013-02-02 00:00:00 |  | Data Management | Active
115 |  |  | 2013-03-11 00:00:00 |  | Compliance Management | Term | Resigned | 2020-04-02 00:00:00
118 |  |  | 2013-03-23 00:00:00 |  | Data Management | Active
122 |  |  | 2013-05-12 00:00:00 |  |  | Active
123 |  |  | 2013-05-21 00:00:00 |  | Product Management | Active
126 |  |  | 2013-05-13 00:00:00 |  | Legal Affairs | Active
129 |  |  | 2013-05-12 00:00:00 |  | Shared Services | Active
139 |  |  | 2014-03-31 00:00:00 |  | Compliance Management | Term | Resigned | 2020-05-21 00:00:00
140 |  |  | 2014-04-01 00:00:00 |  | Shared Services | Active
143 |  |  | 2014-05-25 00:00:00 |  | Communication & Marketing | Active
150 |  |  | 2014-09-14 00:00:00 |  | Information Technology | Active
153 |  |  | 2014-10-23 00:00:00 |  | Information Technology | Active
157 |  |  | 2014-12-03 00:00:00 |  |  | Active
158 |  |  | 2014-12-28 00:00:00 |  | Shared Services | Active
176 |  |  | 2015-06-07 00:00:00 |  |  | Active
180 |  |  | 2015-07-01 00:00:00 |  | Data Management | Active
183 |  |  | 2015-07-26 00:00:00 |  | Information Technology | Term | Resigned | 2020-07-25 00:00:00
184 |  |  | 2015-07-26 00:00:00 |  | Information Technology | Active
186 |  |  | 2015-08-02 00:00:00 |  | Internal Audit | Active
188 |  |  | 2015-08-09 00:00:00 |  | CEO Office | Active
189 |  |  | 2015-08-23 00:00:00 |  | Communication & Marketing | Active
190 |  |  | 2015-09-01 00:00:00 |  | Information Technology | Active
193 |  |  | 2015-09-01 00:00:00 |  | Shared Services | Active
197 |  |  | 2015-09-01 00:00:00 |  | Business Development | Active
201 |  |  | 2015-10-04 00:00:00 |  | Compliance Management | Active
205 |  |  | 2015-10-20 00:00:00 |  |  | Active
209 |  |  | 2015-11-01 00:00:00 |  |  | Active
214 |  |  | 2016-01-10 00:00:00 |  | Legal Affairs | Active
215 |  |  | 2016-02-07 00:00:00 |  |  | Active
217 |  |  | 2016-02-21 00:00:00 |  |  | Active
218 |  |  | 2016-02-21 00:00:00 |  |  | Active
219 |  |  | 2016-03-01 00:00:00 |  |  | Active
221 |  |  | 2016-03-06 00:00:00 |  | Business Development | Active
225 |  |  | 2016-03-20 00:00:00 |  | Shared Services | Active
226 |  |  | 2016-03-20 00:00:00 |  | Information Technology | Term | Resigned | 2020-04-02 00:00:00
230 |  | 1976-06-20 00:00:00 | 2016-04-10 00:00:00 |  | Information Technology | Active
235 |  |  | 2016-06-08 00:00:00 |  | Communication & Marketing | Active
239 |  |  | 2016-07-17 00:00:00 |  | Shared Services | Active
240 |  |  | 2016-08-21 00:00:00 |  | Shared Services | Active
241 |  |  | 2016-08-14 00:00:00 |  | Information Technology | Active
242 |  |  | 2016-08-14 00:00:00 |  | Information Technology | Active
243 |  |  | 2016-08-07 00:00:00 |  |  | Active
246 |  |  | 2019-09-18 00:00:00 |  | Information Technology | Active
253 |  |  | 2016-12-07 00:00:00 |  | Information Technology | Active
256 |  |  | 2016-12-07 00:00:00 |  | Information Technology | Active
258 |  |  | 2017-01-01 00:00:00 |  | Business Development | Active
261 |  |  | 2017-01-01 00:00:00 |  | Information Technology | Active
272 |  |  | 2017-05-01 00:00:00 |  | Shared Services | Active
277 |  |  | 2017-05-21 00:00:00 |  | Shared Services | Active
287 |  |  | 2017-12-11 00:00:00 |  | Shared Services | Active
288 |  |  | 2018-01-07 00:00:00 |  |  | Active
295 |  |  | 2018-03-11 00:00:00 |  | CEO Office | Active
296 |  |  | 2018-03-11 00:00:00 |  | Data Management | Term | Resigned | 2020-03-31 00:00:00
297 |  |  | 2018-04-08 00:00:00 |  | Internal Audit | Active
298 |  |  | 2018-04-08 00:00:00 |  | Shared Services | Active
300 |  |  | 2018-05-01 00:00:00 |  | Communication & Marketing | Active
301 |  |  | 2018-05-01 00:00:00 |  | Information Technology | Term | Resigned | 2020-03-01 00:00:00
305 |  |  | 2018-05-27 00:00:00 |  |  | Active
313 |  |  | 2018-06-24 00:00:00 |  | Business Development | Active
317 |  |  | 2018-06-03 00:00:00 |  | Product Management | Active
318 |  |  | 2018-06-05 00:00:00 |  | Shared Services | Active
319 |  |  | 2018-06-03 00:00:00 |  | Legal Affairs | Active
328 |  |  | 2019-11-03 00:00:00 |  | Information Technology | Active
329 |  |  | 2018-08-01 00:00:00 |  | Business Development | Active
340 |  |  | 2018-11-04 00:00:00 |  | Information Technology | Active
346 |  |  | 2018-12-31 00:00:00 |  | Shared Services | Active
347 |  |  | 2018-12-09 00:00:00 |  | Data Management | Active
349 |  |  | 2019-03-03 00:00:00 |  | Data Management | Active
350 |  |  | 2019-02-10 00:00:00 |  | Risk Management | Term | Resigned | 2020-06-18 00:00:00
356 |  |  | 2019-03-13 00:00:00 |  | Strategic Planning & PMO | Active
357 |  |  | 2019-04-07 00:00:00 |  | Data Management | Active
360 |  |  | 2019-05-19 00:00:00 |  | Strategic Planning & PMO | Active
361 |  |  | 2019-06-16 00:00:00 |  | Risk Management | Active
362 |  |  | 2019-06-16 00:00:00 |  | Legal Affairs | Active
364 |  |  | 2019-06-23 00:00:00 |  |  | Active
371 |  |  | 2019-06-09 00:00:00 |  | Data Management | Active
372 |  | 1997-10-31 00:00:00 | 2020-03-12 00:00:00 |  | Shared Services | Active
377 |  |  | 2019-07-07 00:00:00 |  | Business Development | Active
378 |  |  | 2019-07-21 00:00:00 |  | Business Development | Active
379 |  |  | 2019-07-21 00:00:00 |  | Compliance Management | Active
380 |  |  | 2019-09-01 00:00:00 |  | Risk Management | Active
382 |  |  | 2019-09-01 00:00:00 |  | Communication & Marketing | Active
387 |  |  | 2019-10-01 00:00:00 |  | Communication & Marketing | Active
388 |  |  | 2019-10-13 00:00:00 |  | Shared Services | Active
389 |  |  | 2019-09-01 00:00:00 |  | Information Technology | Active
396 |  |  | 2019-10-30 00:00:00 |  | Information Technology | Active
397 |  |  | 2019-12-15 00:00:00 |  | Communication & Marketing | Active
398 |  |  | 2019-12-01 00:00:00 |  | Information Technology | Active
399 |  |  | 2020-01-05 00:00:00 |  | Information Technology | Active
401 |  |  | 2019-12-15 00:00:00 |  | Internal Audit | Term | Resigned | 2020-06-23 00:00:00
402 |  |  | 2019-12-08 00:00:00 |  | Information Technology | Active
403 |  |  | 2020-01-10 00:00:00 |  | Product Management | Active
404 |  |  | 2019-12-15 00:00:00 |  | Information Technology | Active
405 |  |  | 2019-12-15 00:00:00 |  | Internal Audit | Term | Resigned | 2020-03-15 00:00:00
406 |  |  | 2019-12-23 00:00:00 |  | Information Technology | Term | Resigned | 2020-06-04 00:00:00
407 |  |  | 2020-01-05 00:00:00 |  | Compliance Management | Term | Resigned | 2020-04-02 00:00:00
408 |  |  | 2020-01-05 00:00:00 |  | Product Management | Active
412 |  |  | 2020-01-19 00:00:00 |  | Product Management | Active
415 |  |  | 2020-02-02 00:00:00 |  | Business Development | Term | Resigned | 2020-03-12 00:00:00
421 |  |  | 2020-02-16 00:00:00 |  | Risk Management | Term | Resigned | 2020-04-30 00:00:00
423 |  |  | 2020-02-19 00:00:00 |  | Information Technology | Active
427 |  |  | 2020-03-15 00:00:00 |  | Risk Management | Active
429 |  |  | 2020-02-16 00:00:00 |  | Information Technology | Active
430 |  |  | 2020-04-12 00:00:00 |  | Compliance Management | Term | Resigned | 2020-06-24 00:00:00
431 |  |  | 2020-04-12 00:00:00 |  | Information Technology | Active
432 |  |  | 2020-05-03 00:00:00 |  | Compliance Management | Active
433 |  |  | 2020-05-10 00:00:00 |  | Compliance Management | Active
435 |  | 1997-03-25 00:00:00 | 2020-06-07 00:00:00 |  | Product Management | Active
438 |  | 1993-08-17 00:00:00 | 2020-06-07 00:00:00 |  | Internal Audit | Active
436 |  |  | 2020-06-21 00:00:00 |  | Data Management | Active
443 |  |  | 2020-06-23 00:00:00 |  | Information Technology | Active
442 |  |  | 2020-07-05 00:00:00 |  | Information Technology | Active
444 |  |  | 2020-07-19 00:00:00 |  | Data Management | Active
446 |  |  | 2020-07-22 00:00:00 |  | Compliance Management | Active