Spreadsheet: 455582d1460408158-lookup-function-finding-most-recent-dates-example
Sheet: Sheet1

Last Five Leases Signed |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unit ID | Lease Start | Gross Potential
 | eb10 | 1b10 | 1c10 | 1d10 | 1e10 | 2a20 |  |  |  |  |  |  |  |  | 1c10 | 2015-09-30 00:00:00 | 525
Lease 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2014-11-30 00:00:00 | 485
Lease 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-08-31 00:00:00 | 86
Lease 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-03-31 00:00:00 | 575
Lease 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-05-31 00:00:00 | 100
Lease 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-03-31 00:00:00 | 550
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-06-30 00:00:00 | 570
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2014-10-31 00:00:00 | 525
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-04-30 00:00:00 | 485
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2014-12-31 00:00:00 | 525
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-01-31 00:00:00 | 515
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-01-31 00:00:00 | 525
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2014-10-31 00:00:00 | 480
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2014-11-30 00:00:00 | 525
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2014-10-31 00:00:00 | 510
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-02-28 00:00:00 | 535
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eb10 | 2015-07-31 00:00:00 | 455
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eb10 | 2014-12-31 00:00:00 | 420
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eb10 | 2015-09-30 00:00:00 | 445
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eb10 | 2015-08-31 00:00:00 | 440
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eb10 | 2014-10-31 00:00:00 | 455
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eb10 | 2015-06-30 00:00:00 | 455
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eb10 | 2015-05-31 00:00:00 | 420
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eb10 | 2015-08-31 00:00:00 | 420
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2015-09-30 00:00:00 | 480
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2015-09-30 00:00:00 | 470
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2015-03-31 00:00:00 | 105
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2015-03-31 00:00:00 | 424
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2015-04-30 00:00:00 | 465
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2015-08-31 00:00:00 | 465
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2015-03-31 00:00:00 | 470
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2015-07-31 00:00:00 | 480
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2015-09-30 00:00:00 | 420
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2015-01-31 00:00:00 | 480
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2015-06-30 00:00:00 | 460
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2015-02-28 00:00:00 | 490
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2015-02-28 00:00:00 | 495
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2015-01-31 00:00:00 | 485
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2015-09-30 00:00:00 | 495
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2014-11-30 00:00:00 | 455
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eb10 | 2014-10-31 00:00:00 | 207.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eb10 | 2015-06-30 00:00:00 | 455
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eb10 | 2015-01-31 00:00:00 | 420
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eb10 | 2015-04-30 00:00:00 | 460
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eb10 | 2015-09-30 00:00:00 | 460
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eb10 | 2015-07-31 00:00:00 | 420
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eb10 | 2015-07-31 00:00:00 | 420
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eb10 | 2015-04-30 00:00:00 | 425
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eb10 |  | 460
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eb10 | 2015-06-30 00:00:00 | 415
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eb10 | 2014-11-30 00:00:00 | 440
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eb10 | 2014-12-31 00:00:00 | 410
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1e10 | 2015-09-30 00:00:00 | 725
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eb10 | 2014-11-30 00:00:00 | 415
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eb10 | 2014-12-31 00:00:00 | 405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-09-30 00:00:00 | 505
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 |  | 560
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 |  | 560
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 |  | 560
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2014-10-31 00:00:00 | 560
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-05-31 00:00:00 | 550
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-02-28 00:00:00 | 650
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2014-12-31 00:00:00 | 470
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-05-31 00:00:00 | 550
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-03-31 00:00:00 | 650
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-01-31 00:00:00 | 520
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-04-30 00:00:00 | 520
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-06-30 00:00:00 | 650
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 |  | 560
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-01-31 00:00:00 | 530
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-06-30 00:00:00 | 275
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-05-31 00:00:00 | 560
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-09-30 00:00:00 | 520
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2014-10-31 00:00:00 | 490
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2014-11-30 00:00:00 | 525
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2a20 |  | 950
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-02-28 00:00:00 | 530
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 |  | 560
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2014-11-30 00:00:00 | 515
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-04-30 00:00:00 | 525
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 |  | 560
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-02-28 00:00:00 | 520
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-09-30 00:00:00 | 535
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 |  | 560
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 |  | 560
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-09-30 00:00:00 | 545
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-07-31 00:00:00 | 515
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-10-31 00:00:00 | 510
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 |  | 560
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 |  | 560
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-05-31 00:00:00 | 540
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-02-28 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2014-11-30 00:00:00 | 435
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-03-31 00:00:00 | 495
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2014-10-31 00:00:00 | 550
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 |  | 560
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-02-28 00:00:00 | 460
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2014-11-30 00:00:00 | 102
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2014-12-31 00:00:00 | 515
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-08-31 00:00:00 | 75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2015-01-31 00:00:00 | 460
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1c10 | 2014-10-31 00:00:00 | 445
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2015-05-31 00:00:00 | 480
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2015-02-28 00:00:00 | 465
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2015-07-31 00:00:00 | 420
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2015-04-30 00:00:00 | 470
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2015-07-31 00:00:00 | 460
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2014-10-31 00:00:00 | 460
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 |  | 500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 |  | 500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2014-11-30 00:00:00 | 470
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2015-05-31 00:00:00 | 480
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2015-04-30 00:00:00 | 460
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2014-09-30 00:00:00 | 470
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2014-12-31 00:00:00 | 480
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2014-11-30 00:00:00 | 490
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2015-03-31 00:00:00 | 475
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1b10 | 2014-10-31 00:00:00 | 485
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1d10 | 2014-12-31 00:00:00 | 530
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1d10 | 2015-07-31 00:00:00 | 540
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1d10 | 2015-04-30 00:00:00 | 605
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1d10 | 2014-11-30 00:00:00 | 555
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1d10 | 2015-01-31 00:00:00 | 565
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1d10 | 2015-09-30 00:00:00 | 570
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1d10 | 2015-02-28 00:00:00 | 510
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1d10 | 2014-10-31 00:00:00 | 575
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1d10 | 2015-03-31 00:00:00 | 580
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1d10 | 2014-12-31 00:00:00 | 570
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1d10 | 2015-03-31 00:00:00 | 570
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1d10 | 2014-09-30 00:00:00 | 560
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1d10 |  | 600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1d10 | 2014-12-31 00:00:00 | 550
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1d10 | 2014-11-30 00:00:00 | 560
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1d10 | 2015-03-31 00:00:00 | 560