Hello everyone...

I have a column in a worksheet that finds the latest date in a column (This
is the lastest paid date). Now, I want to have the amoutn paid which is in
the cell next to date paid to show

ie.
Date Amt pd Ck#
8/31/2004 ($25) 902 Last pymt 7/29/2005
9/18/2004 ($25) 914 Last pymt amt XXXXXXX
11/4/2004 ($25) 936
1/14/2005 ($50) 980
7/29/2005 ($100) 1070

I want XXXXXXX to show automatically $100

Thanks! Tara