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