Hello,
I have workbook with 2 sheets
Sheet1 = Results
Col1 = ID
Col2 = Result_Record Datetime
Col3 = Result
Sheet2 = Goals
Col1 = ID
Col2 = GoalSet Datetime
Col3 = Goal
For each row in the Results sheet, I need to lookup the ID in the GOAL sheet and find the goal that was set prior to the result record datetime
I single ID may have several recorded Goals - I just need the one that was set right before the results
I appreciate any guidance
Thanks
Steve
Bookmarks