Thank you, this was exaclty what I was looking for.

"Fred Smith" wrote:

Assuming the dates in row 1 are actual Excel dates, just use Today() in an
Hlookup, as in:

=Hlookup(today(),$1:$2,2,false)

Regards,
Fred.

"GaryS" wrote in message
...
I have a spreadsheet, in one worksheet I have a row of dates, then below a
row of data.
A,B,C (Columns)
1 01/01,01/02,01/03 (Rows with Dates)
2 100,200,300 (Row with Data)

On another worksheet I have a cell that I want to populate based on the
previous worksheet's data, but only if the date in column 1 equals today's
date.

So if today's date is 01/01 the cell would populate with 100. If today's
date was 01/02 it would popualte with 200, etc.