Spreadsheet: 549690d1511877398-lookup-in-range-which-is-in-dependence-of-another-column-and-return-a-different-column-date-in-range-return-percentage
Sheet: HR Query

Pers.No. | Different empl.% | Last name | First name | Employee Group | Personnel Subarea | Empl. % | [NAME] | Wk.hrs. | Planned Work.  Time Start Date | Planned Working Time End Date | Part timer in a period? | Quantity of part time months
2861 | 2 | [NAME] | Mairi | Staff Member | Berlin |  | 169 | 39 | 2014-09-01 00:00:00 | 2016-12-31 00:00:00 | Yes
2861 | 2 | [NAME] | Mairi | Staff Member | Berlin |  | 86.66 | 20 | 2017-01-01 00:00:00 | 2017-06-18 00:00:00 | Yes
9961 | 3 | Petri | Marzia | Staff Member | Berlin |  | 169 | 39 | 2013-10-01 00:00:00 | 2015-04-30 00:00:00 | Yes
9961 | 3 | Petri | Marzia | Staff Member | Berlin |  | 129.99 | 30 | 2015-05-01 00:00:00 | 2015-12-31 00:00:00 | Yes
9961 | 3 | Petri | Marzia | Staff Member | Berlin |  | 138.66 | 32 | 2016-01-01 00:00:00 | 2016-06-30 00:00:00 | Yes
10401 | 2 | Yong | Susanna | Staff Member | London |  | 169 | 39 | 2014-04-01 00:00:00 | 2014-11-04 00:00:00 | Yes
10401 | 2 | Yong | Susanna | Staff Member | London |  | 86.66 | 20 | 2014-11-05 00:00:00 | 2015-01-18 00:00:00 | Yes
10981 | 2 | [NAME] | Paola | Staff Member | London |  | 138.66 | 32 | 2012-02-01 00:00:00 | 2015-10-31 00:00:00 | Yes
10981 | 2 | [NAME] | Paola | Staff Member | London |  | 169 | 39 | 2015-11-01 00:00:00 | 2015-12-31 00:00:00 | Yes
11514 | 5 | [NAME] | Ramona | Staff Member | Berlin |  | 169 | 39 | 2014-08-01 00:00:00 | 2014-08-31 00:00:00 | Yes
11514 | 5 | [NAME] | Ramona | Staff Member | Berlin |  | 104 | 24 | 2015-05-01 00:00:00 | 2015-12-31 00:00:00 | Yes
11514 | 5 | [NAME] | Ramona | Staff Member | Berlin |  | 121.33 | 28 | 2016-01-01 00:00:00 | 2016-07-31 00:00:00 | Yes
11514 | 5 | [NAME] | Ramona | Staff Member | Berlin |  | 138.66 | 32 | 2016-08-01 00:00:00 | 2016-12-31 00:00:00 | Yes
11514 | 5 | [NAME] | Ramona | Staff Member | Berlin |  | 118.3 | 27.3 | 2017-01-01 00:00:00 | 2017-04-30 00:00:00 | Yes
11851 | 4 | Bock | Vera | Staff Member | London |  | 108.33 | 25 | 2012-08-01 00:00:00 | 2014-09-30 00:00:00 | Yes
11851 | 4 | Bock | Vera | Staff Member | London |  | 33.79 | 7.8 | 2014-10-01 00:00:00 | 2016-04-10 00:00:00 | Yes
11851 | 4 | Bock | Vera | Staff Member | London |  | 86.66 | 20 | 2016-04-11 00:00:00 | 2016-04-30 00:00:00 | Yes
11851 | 4 | Bock | Vera | Staff Member | London |  | 169 | 39 | 2016-05-01 00:00:00 | 2017-10-31 00:00:00 | Yes
11982 | 3 | Woodall | [NAME] | Staff Member | London |  | 169 | 39 | 2012-10-01 00:00:00 | 2016-09-30 00:00:00 | Yes
11982 | 3 | Woodall | [NAME] | Staff Member | London |  | 147.33 | 34 | 2016-10-01 00:00:00 | 2017-08-31 00:00:00 | Yes
11982 | 3 | Woodall | [NAME] | Staff Member | London |  | 129.99 | 30 | 2017-09-01 00:00:00 | 2017-10-31 00:00:00 | Yes
12029 | 2 | Crawte | Walden | Staff Member | London |  | 117 | 27 | 2012-10-18 00:00:00 | 2016-01-31 00:00:00 | Yes
12029 | 2 | Crawte | Walden | Staff Member | London |  | 135.2 | 31.2 | 2016-02-01 00:00:00 | 2016-09-30 00:00:00 | Yes
12065 | 2 | Emery | [NAME] | Staff Member | London |  | 169 | 39 | 2012-11-01 00:00:00 | 2017-01-31 00:00:00 | Yes
12065 | 2 | Emery | [NAME] | Staff Member | London |  | 138.66 | 32 | 2017-02-01 00:00:00 | 2017-04-30 00:00:00 | Yes
13242 | 3 | Pfeiffer | Maria | Trainee / MasterStud | London |  | 78.44 | 18.1 | 2014-10-07 00:00:00 | 2015-01-31 00:00:00 | Yes
13242 | 3 | Pfeiffer | Maria | Trainee / MasterStud | London |  | 86.67 | 20 | 2015-02-01 00:00:00 | 2015-05-10 00:00:00 | Yes
13242 | 3 | Pfeiffer | Maria | Trainee / MasterStud | London |  | 169 | 39 | 2015-05-11 00:00:00 | 2015-08-31 00:00:00 | Yes