One way,

In B1: =TODAY()

Select B2:B10

Put in the formula bar, and array-enter
(press CTRL+SHIFT+ENTER):

=OFFSET($C$2:$C$10,,MATCH(B1,$C$1:$IV$1,0)-1)

B2:B10 will return the required values
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Jeff" wrote in message
...
I have an issue and I am not quite sure how to solve it.

I have a table, for the purposes of this example

Column #1 = Names of People
Column #2 = Value I am looking for

Row #1 = Date Values 12/1, 12/2 etc.
Rows 2-10 values 46,50,60 etc.

I would like a formula that based on todays date return the value in the
column associated to that date to column #2

the expected result would be that on Day 1
Column 3 = 12/1 values in Column 3 are the values displayed in Column 2
On Day 10
Column 13 = 12/10 and values from column 10 are the values displayed in
column 2 without any interaction from me, the lazy user.

Using the Today() function to set the day to look for seems right but I
can't get the rest.

Thanks
--
Jeff