robfoster2000
New Member
- Joined
- Dec 14, 2009
- Messages
- 8
Hi all.
This is my first post so please be gentle!
I have a list of dates in column A which range from a few months ago and into next year. For each date, there is a corresponding value in column B.
I need a formula which, based on today's date, finds the most recent date and returns the corresponding value from column B.
E.G.
Today's date = 14th Dec 2009
Dates Values
04th Dec 10
11th Dec 20
18th Dec 30
Need the formula to return 20 as this is the most relevant value.
Any help would be much appreciated!
Cheers,
Rob.
This is my first post so please be gentle!
I have a list of dates in column A which range from a few months ago and into next year. For each date, there is a corresponding value in column B.
I need a formula which, based on today's date, finds the most recent date and returns the corresponding value from column B.
E.G.
Today's date = 14th Dec 2009
Dates Values
04th Dec 10
11th Dec 20
18th Dec 30
Need the formula to return 20 as this is the most relevant value.
Any help would be much appreciated!
Cheers,
Rob.