Evening All

Please can somebody help me?

I have made a budget spreadsheet.

In cell C139 I have todays date: =TEXT(TODAY(),"d mmm yyyy")

In column D (D140:D1171) I have a list of dates (formatted as Sun
6-Feb-2005)

In column AH I have a formula to calculate the total figure that I am
going to spend on the date entered in column D. For example, the
formula looks like this:
=IF(AE3900,AD390+AE390,IF(AF3900,AD390-AF390,AD390))

I would like to write a formula in cell C140 that looks for the date in
cell C139 in the list of dates in column D and reports back the
corresponding amount of money in column AH that I have budgeted to
spend for today. How do?

Thanks in advance!


--
Prospero
------------------------------------------------------------------------
Prospero's Profile: http://www.excelforum.com/member.php...o&userid=13801
View this thread: http://www.excelforum.com/showthread...hreadid=342728