Cumlative figures - relate to TODAY()

Hi,

I am working on sales data that cross-references various numbers.

As a part of this, I need to be able to display a cumlative number that is the cell adjacent to today's date.

Example:

Column A shows 10, 20, 30 etc. (So cell A3 shows a value of 30)

Column B shows date Jan 1, Jan 2, Jan 3 (So cell B3 shows "Jan 3")

On a seperate sheet, I have a cell showing today's date.

Assuming today is January 3rd, I need Excel to display the value of cell A3.

The next day, when Excel updates the date, I need it to show cell A4 - on so on...

Hope that makes sense?!

=INDEX(A1:A30,MATCH(TODAY(),B1:B30,0)) adjust ranges to suit