Please help. I've been searching and trying different index/match formulas, but I can not get this right. I need to find the closest date of status change to the payroll date.
|EE Name||Status Change||FTE||Employee Name||Payroll Start Date||<== Lookup criteria|
|John Doe||5/5/2014||1.00||John Doe||8/1/2014|
|Bernie Sanders||9/25/2014||0.50||goal is to get ==>||0.50|
|Marco Rubio||6/12/2014||0.80||from cell C6|
|Lookup values: 1 = Employee Name, 2 is payroll date:|