Hi guys,
i need help to work on an excel formula to lookup for last transaction. my sample is below. I need to lookup for previous data (date and status) but cant find a solution.
Current Transaction Previous Attempt
Date Ref Status Date Status
Jan-2017 123 Unsuccessful – –
Jan-2017 abc Unsuccessful – –
Feb-2017 123 Successful 01-2017 Unsuccessful
Feb-2017 abc Successful 01-2017 Unsuccessful
Mar-2017 123 Successful 02-2017 Successful
Mar-2017 abc Successful 02-2017 Successful
Apr-2017 123 Successful 03-2017 Successful
Apr-2017 abc Unsuccessful 03-2017 Successful
