Lookup formula that matches name and selects the closest date that is greater than lookup

The example is a simpler version of the spreadsheet I am working on and contains confidential information. The best way to think about this spreadsheet is to think of two library books and tracking their in and out time. I have a report that pulls the check out time and a report that pulls the check in time. Both are dropped into excel on appropriate tabs. I need to have both dates on one sheet.

First sheet has 4 columns with the last one being the date from the second sheet
Name Number Date Out Date Returned
ABC 123 1/1/2017 Need Formula
DEF 456 2/2/2017 Need Formula
ABC 123 3/3/2017 Need Formula
DEF 456 3/5/2017 Need Formula
ABC 123 4/4/2017 Need Formula
DEF 456 5/5/2017 Need Formula
ABC 123 5/8/2017 Need Formula

This is the three column Date returned sheet

Name Number Date Returned
ABC 123 2/5/2017
DEF 456 3/2/2017
ABC 123 4/3/2017
DEF 456 4/5/2017
ABC 123 4/21/2017


This is the expected results on the first sheet
Name Number Date Out Date Returned
ABC 123 1/1/2017 2/5/2017
DEF 456 2/2/2017 3/2/2017
ABC 123 3/3/2017 4/3/2017
DEF 456 3/5/2017 4/5/2017
ABC 123 4/4/2017 4/21/2017
DEF 456 5/5/2017
ABC 123 5/8/2017

Thanks this worked as you described but I am now being asked to go to the detail of time of return and check out. I could not get the formula to work with the time for each date. Any suggestions