Problem with LOOKUP function.

I have a workbook which keeps track of money in an account. I use the LOOKUP function to lookup the most recent date in one column and return the corresponding value in another column thereby telling...