Reference current date with desired number

I have a sheet in excel that I want to automatically update everyday based on the information for the current date. This number that needs to be updated daily is on another sheet, it is in column “B’ and the corresponding dates are in column “A”. All these sheets are in the same file. However I cannot figure out how to tell excel to reference the desired number based on the current date.

Can you upload example?

10-Mar-10 87.0
11-Mar-10 87.0
12-Mar-10 87.0
13-Mar-10 87.0
14-Mar-10 87.0
15-Mar-10 87.0
16-Mar-10 87.0
17-Mar-10 87.0
18-Mar-10 87.0
19-Mar-10 87.0
20-Mar-10 87.0
21-Mar-10 87.0
22-Mar-10 87.0
23-Mar-10 83.0
24-Mar-10 83.0
25-Mar-10 83.0
26-Mar-10 83.0


The date would be in column “a” then the list of numbers in column “b”
On another sheet (same file) I just want the number in column “b” to show for that corresponding date (today). I want it to update everyday automatically.

Try:

INDEX(array2, MATCH(TODAY(), array1, 0), )

where arrays are your data on other sheet: array2 is in B column, and array1 is in A column

that worked dude, thanks for your help....

If there is no TODAY defined in your array you'll get Error... Hope that's OK with you (indicates that must be entered).