Array help please

D

David

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
 
S

Stefi

Enter in an appropriate cell (where you want the result):

=HLOOKUP(TODAY();A$1:H$2;2)

Regards,
Stefi

„David†ezt írta:
 
B

bj

I suggest for this you use today() rather than now(). now() includes the time
so that now() ten minutes from now is not the same as now() now
but try
=index(start row 1 location:end of row 2 data,2,match(today(),row1data,0)-1))
 
D

David

bj
Thanks for your response
--
David


bj said:
I suggest for this you use today() rather than now(). now() includes the time
so that now() ten minutes from now is not the same as now() now
but try
=index(start row 1 location:end of row 2 data,2,match(today(),row1data,0)-1))

David said:
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
Click to expand...
Click to expand...
 
D

David

Stefi
Thanks for your response
--
David


Stefi said:
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
Click to expand...
Click to expand...
 
Top