Stefi
Thanks for your response
--
David
"Stefi" wrote:
Enter in an appropriate cell (where you want the result):
=HLOOKUP(TODAY();A$1:H$2;2)
Regards,
Stefi
€žDavid€ť ezt Ă*rta:
In row 1 i have a series of dates in asscending order.
In row 2 I have values coresponding to the dates in row 1.
I am hoping to pick out the value in rows 2 that corrsponds to the most
recent date in row 1 that is less than todays date [ie <now()]
Any suggestions will be much appreciated
TIA
--
David
|