Spreadsheet: 689353d1596332096-how-to-reference-data-based-on-formula-result-sample-bvj-
Sheet: Core_Dataset

EmpID | Worker Name | DOB | DateofHire | Position | Department | EmpStatus | TermType | DateofTermination
3 | Employee3873 |  | 2004-04-01 00:00:00 | PM79 | Product Management | Active
6 | Employee7682 |  | 2004-04-01 00:00:00 | PM30 | Product Management | Active
7 | Employee7706 |  | 2005-08-15 00:00:00 | SP65 | Strategic Planning & PMO | Active
9 | Employee6245 |  | 2005-09-25 00:00:00 | CM63 | Compliance Management | Active
10 | Employee2050 |  | 2006-05-20 00:00:00 |  |  | Active
11 | Employee8615 |  | 2006-05-20 00:00:00 | IT56 | Information Technology | Active
14 | [NAME] |  | 2007-03-17 00:00:00 | SS27 | Shared Services | Active
15 | Employee8621 |  | 2007-04-28 00:00:00 | PM2 | Product Management | Active
17 | Employee2041 |  | 2007-11-10 00:00:00 | PM86 | Product Management | Active
18 | Employee7920 |  | 2008-03-15 00:00:00 | SS9 | Shared Services | Active
20 | Employee7523 |  | 2008-04-15 00:00:00 | C&51 | Communication & Marketing | Active
22 | Employee9027 |  | 2008-08-10 00:00:00 | SS42 | Shared Services | Active
23 | Employee6825 |  | 2008-08-10 00:00:00 | CO84 | CEO Office | Active
30 | Employee5446 |  | 2009-05-16 00:00:00 | PM76 | Product Management | Active
32 | Employee4192 |  | 2009-06-01 00:00:00 | DM48 | Data Management | Active
34 | Employee1502 |  | 2009-06-01 00:00:00 | [NAME] | Compliance Management | Term | Resigned | 2020-02-08 00:00:00
37 | Employee9907 |  | 2009-09-02 00:00:00 | IT98 | Information Technology | Term | Resigned | 2020-06-11 00:00:00
42 | Employee3982 |  | 2010-03-02 00:00:00 | SS35 | Shared Services | Active
47 | Employee1362 |  | 2010-05-01 00:00:00 | DM54 | Data Management | Active
49 | Employee9958 |  | 2010-05-08 00:00:00 | BD14 | Business Development | Active
52 | Employee890 |  | 2010-07-17 00:00:00 | CM7 | Compliance Management | Active
55 | Employee3858 |  | 2010-10-09 00:00:00 |  |  | Active
60 | Employee3608 |  | 2010-11-06 00:00:00 | SS76 | Shared Services | Active
61 | Employee7641 |  | 2010-11-06 00:00:00 |  |  | Active
66 | Employee5711 |  | 2011-08-13 00:00:00 | [NAME] | Data Management | Active
73 | Employee3161 |  | 2011-12-19 00:00:00 | C&1 | Communication & Marketing | Active
76 | Employee3173 |  | 2012-01-02 00:00:00 | DM36 | Data Management | Active
87 | Employee6688 |  | 2012-04-01 00:00:00 | IT48 | Information Technology | Active
92 | Employee5594 |  | 2012-05-12 00:00:00 | C&42 | Communication & Marketing | Active
104 | Employee584 |  | 2013-01-05 00:00:00 | BD23 | Business Development | Active
109 | Employee5026 |  | 2013-02-02 00:00:00 | DM18 | Data Management | Active
115 | Employee4240 |  | 2013-03-11 00:00:00 | CM75 | Compliance Management | Term | Resigned | 2020-04-02 00:00:00
118 | Employee547 |  | 2013-03-23 00:00:00 | DM72 | Data Management | Active
122 | Employee9255 |  | 2013-05-12 00:00:00 |  |  | Active
123 | Employee3877 |  | 2013-05-21 00:00:00 | PM69 | Product Management | Active
126 | Employee7090 |  | 2013-05-13 00:00:00 | LA40 | Legal Affairs | Active
129 | Employee2709 |  | 2013-05-12 00:00:00 | SS54 | Shared Services | Active
139 | Employee8760 |  | 2014-03-31 00:00:00 | CM44 | Compliance Management | Term | Resigned | 2020-05-21 00:00:00
140 | Employee2348 |  | 2014-04-01 00:00:00 | SS58 | Shared Services | Active
143 | Employee6852 |  | 2014-05-25 00:00:00 | C&29 | Communication & Marketing | Active
150 | Employee7260 |  | 2014-09-14 00:00:00 | IT22 | Information Technology | Active
153 | Employee5301 |  | 2014-10-23 00:00:00 | IT83 | Information Technology | Active
157 | Employee2059 |  | 2014-12-03 00:00:00 |  |  | Active
158 | Employee3734 |  | 2014-12-28 00:00:00 | SS94 | Shared Services | Active
176 | Employee7173 |  | 2015-06-07 00:00:00 |  |  | Active
180 | Employee3800 |  | 2015-07-01 00:00:00 | DM79 | Data Management | Active
183 | Employee4393 |  | 2015-07-26 00:00:00 | IT64 | Information Technology | Term | Resigned | 2020-07-25 00:00:00
184 | Employee1967 |  | 2015-07-26 00:00:00 | IT38 | Information Technology | Active
186 | Employee977 |  | 2015-08-02 00:00:00 | IA11 | Internal Audit | Active
188 | Employee5958 |  | 2015-08-09 00:00:00 | CO42 | CEO Office | Active
189 | Employee4575 |  | 2015-08-23 00:00:00 | C&67 | Communication & Marketing | Active
190 | Employee2329 |  | 2015-09-01 00:00:00 | IT95 | Information Technology | Active
193 | Employee5801 |  | 2015-09-01 00:00:00 | SS97 | Shared Services | Active
197 | Employee8429 |  | 2015-09-01 00:00:00 | BD42 | Business Development | Active
201 | Employee694 |  | 2015-10-04 00:00:00 | CM88 | Compliance Management | Active
205 | Employee691 |  | 2015-10-20 00:00:00 |  |  | Active
209 | Employee3433 |  | 2015-11-01 00:00:00 |  |  | Active
214 | Employee5741 |  | 2016-01-10 00:00:00 | LA32 | Legal Affairs | Active
215 | Employee1749 |  | 2016-02-07 00:00:00 |  |  | Active
217 | Employee2926 |  | 2016-02-21 00:00:00 |  |  | Active
218 | Employee7991 |  | 2016-02-21 00:00:00 |  |  | Active
219 | Employee5731 |  | 2016-03-01 00:00:00 |  |  | Active
221 | Employee3365 |  | 2016-03-06 00:00:00 | BD67 | Business Development | Active
225 | Employee2261 |  | 2016-03-20 00:00:00 | SS65 | Shared Services | Active
226 | Employee6051 |  | 2016-03-20 00:00:00 | IT66 | Information Technology | Term | Resigned | 2020-04-02 00:00:00
230 | Employee9010 | 1976-06-20 00:00:00 | 2016-04-10 00:00:00 | IT56 | Information Technology | Active
235 | Employee3985 |  | 2016-06-08 00:00:00 | C&53 | Communication & Marketing | Active
239 | Employee4692 |  | 2016-07-17 00:00:00 | SS68 | Shared Services | Active
240 | Employee5734 |  | 2016-08-21 00:00:00 | SS92 | Shared Services | Active
241 | Employee1557 |  | 2016-08-14 00:00:00 | IT89 | Information Technology | Active
242 | Employee2881 |  | 2016-08-14 00:00:00 | IT24 | Information Technology | Active
243 | Employee9612 |  | 2016-08-07 00:00:00 |  |  | Active
246 | Employee9691 |  | 2019-09-18 00:00:00 | IT91 | Information Technology | Active
253 | Employee6036 |  | 2016-12-07 00:00:00 | [NAME] | Information Technology | Active
256 | Employee4653 |  | 2016-12-07 00:00:00 | IT49 | Information Technology | Active
258 | Employee4574 |  | 2017-01-01 00:00:00 | BD3 | Business Development | Active
261 | Employee4123 |  | 2017-01-01 00:00:00 | IT28 | Information Technology | Active
272 | Employee829 |  | 2017-05-01 00:00:00 | SS96 | Shared Services | Active
277 | Employee2912 |  | 2017-05-21 00:00:00 | SS11 | Shared Services | Active
287 | Employee9129 |  | 2017-12-11 00:00:00 | SS38 | Shared Services | Active
288 | Employee9212 |  | 2018-01-07 00:00:00 |  |  | Active
295 | Employee6419 |  | 2018-03-11 00:00:00 | CO57 | CEO Office | Active
296 | Employee8596 |  | 2018-03-11 00:00:00 | DM22 | Data Management | Term | Resigned | 2020-03-31 00:00:00
297 | Employee7813 |  | 2018-04-08 00:00:00 | IA75 | Internal Audit | Active
298 | Employee2540 |  | 2018-04-08 00:00:00 | SS28 | Shared Services | Active
300 | Employee624 |  | 2018-05-01 00:00:00 | C&56 | Communication & Marketing | Active
301 | Employee9485 |  | 2018-05-01 00:00:00 | IT40 | Information Technology | Term | Resigned | 2020-03-01 00:00:00
305 | Employee2128 |  | 2018-05-27 00:00:00 |  |  | Active
313 | Employee9953 |  | 2018-06-24 00:00:00 | BD46 | Business Development | Active
317 | Employee2791 |  | 2018-06-03 00:00:00 | PM79 | Product Management | Active
318 | Employee9709 |  | 2018-06-05 00:00:00 | SS19 | Shared Services | Active
319 | Employee4709 |  | 2018-06-03 00:00:00 | LA59 | Legal Affairs | Active
328 | Employee2244 |  | 2019-11-03 00:00:00 | IT23 | Information Technology | Active
329 | Employee9478 |  | 2018-08-01 00:00:00 | BD19 | Business Development | Active
340 | Employee2038 |  | 2018-11-04 00:00:00 | IT1 | Information Technology | Active
346 | Employee9620 |  | 2018-12-31 00:00:00 | SS4 | Shared Services | Active
347 | Employee7621 |  | 2018-12-09 00:00:00 | [NAME] | Data Management | Active
349 | Employee5043 |  | 2019-03-03 00:00:00 | DM28 | Data Management | Active
350 | Employee2079 |  | 2019-02-10 00:00:00 | RM88 | Risk Management | Term | Resigned | 2020-06-18 00:00:00
356 | Employee6302 |  | 2019-03-13 00:00:00 | SP39 | Strategic Planning & PMO | Active
357 | Employee5362 |  | 2019-04-07 00:00:00 | DM82 | Data Management | Active
360 | Employee3425 |  | 2019-05-19 00:00:00 | SP50 | Strategic Planning & PMO | Active
361 | Employee6762 |  | 2019-06-16 00:00:00 | RM50 | Risk Management | Active
362 | Employee4762 |  | 2019-06-16 00:00:00 | LA70 | Legal Affairs | Active
364 | Employee3576 |  | 2019-06-23 00:00:00 |  |  | Active
371 | Employee3160 |  | 2019-06-09 00:00:00 | DM25 | Data Management | Active
372 | Employee9894 | 1997-10-31 00:00:00 | 2020-03-12 00:00:00 | SS83 | Shared Services | Active
377 | Employee6515 |  | 2019-07-07 00:00:00 | BD64 | Business Development | Active
378 | Employee4048 |  | 2019-07-21 00:00:00 | BD39 | Business Development | Active
379 | Employee3957 |  | 2019-07-21 00:00:00 | CM89 | Compliance Management | Active
380 | Employee6493 |  | 2019-09-01 00:00:00 | RM2 | Risk Management | Active
382 | Employee1059 |  | 2019-09-01 00:00:00 | C&43 | Communication & Marketing | Active
387 | Employee1422 |  | 2019-10-01 00:00:00 | C&0 | Communication & Marketing | Active
388 | Employee8957 |  | 2019-10-13 00:00:00 | SS17 | Shared Services | Active
389 | Employee3071 |  | 2019-09-01 00:00:00 | IT34 | Information Technology | Active
396 | Employee8739 |  | 2019-10-30 00:00:00 | IT71 | Information Technology | Active
397 | Employee1910 |  | 2019-12-15 00:00:00 | C&51 | Communication & Marketing | Active
398 | Employee6352 |  | 2019-12-01 00:00:00 | IT29 | Information Technology | Active
399 | Employee8925 |  | 2020-01-05 00:00:00 | IT67 | Information Technology | Active
401 | Employee2331 |  | 2019-12-15 00:00:00 | IA91 | Internal Audit | Term | Resigned | 2020-06-23 00:00:00
402 | Employee5111 |  | 2019-12-08 00:00:00 | IT79 | Information Technology | Active
403 | Employee9974 |  | 2020-01-10 00:00:00 | PM38 | Product Management | Active
404 | Employee6220 |  | 2019-12-15 00:00:00 | IT47 | Information Technology | Active
405 | Employee9035 |  | 2019-12-15 00:00:00 | IA97 | Internal Audit | Term | Resigned | 2020-03-15 00:00:00
406 | Employee5385 |  | 2019-12-23 00:00:00 | IT31 | Information Technology | Term | Resigned | 2020-06-04 00:00:00
407 | Employee2796 |  | 2020-01-05 00:00:00 | CM47 | Compliance Management | Term | Resigned | 2020-04-02 00:00:00
408 | Employee2591 |  | 2020-01-05 00:00:00 | PM2 | Product Management | Active
412 | Employee6299 |  | 2020-01-19 00:00:00 | PM86 | Product Management | Active
415 | Employee9736 |  | 2020-02-02 00:00:00 | BD58 | Business Development | Term | Resigned | 2020-03-12 00:00:00
421 | Employee4243 |  | 2020-02-16 00:00:00 | RM96 | Risk Management | Term | Resigned | 2020-04-30 00:00:00
423 | Employee7534 |  | 2020-02-19 00:00:00 | IT63 | Information Technology | Active
427 | Employee3537 |  | 2020-03-15 00:00:00 | RM45 | Risk Management | Active
429 | Employee3895 |  | 2020-02-16 00:00:00 | IT18 | Information Technology | Active
430 | Employee6615 |  | 2020-04-12 00:00:00 | CM6 | Compliance Management | Term | Resigned | 2020-06-24 00:00:00
431 | Employee2255 |  | 2020-04-12 00:00:00 | IT73 | Information Technology | Active
432 | Employee3191 |  | 2020-05-03 00:00:00 | CM6 | Compliance Management | Active
433 | Employee1526 |  | 2020-05-10 00:00:00 | CM25 | Compliance Management | Active
435 | Employee1417 | 1997-03-25 00:00:00 | 2020-06-07 00:00:00 | PM45 | Product Management | Active
438 | Employee7204 | 1993-08-17 00:00:00 | 2020-06-07 00:00:00 | IA55 | Internal Audit | Active
436 | Employee5478 |  | 2020-06-21 00:00:00 | DM49 | Data Management | Active
443 | Employee439 |  | 2020-06-23 00:00:00 | IT19 | Information Technology | Active
442 | Employee5395 |  | 2020-07-05 00:00:00 | IT14 | Information Technology | Active
444 | Employee237 |  | 2020-07-19 00:00:00 | DM33 | Data Management | Active
446 | Employee1052 |  | 2020-07-22 00:00:00 | CM83 | Compliance Management | Active