Billy,

F1 contains the "=LOOKUP(NOW(),B6:F6)" I was trying to make it a 2-step
process to make it easier.

I need to do this:
Find the date in B6:F6 closest to but less than Now or Today
Go down 2 rows in the corresponding column and get the value.

Mike

"Billy Liddel" wrote:

Mike

F1 has to have a cell reference, hence the REF error. What is in F1?

If A5 contains Art and B10 contains A5 the indirect(B10 returns Art.

Regards
Peter

"Mike K" wrote:

Oh Wise Ones,

I have week ending dates in B6:F6. In F1 I have the formula
=LOOKUP(NOW(),B6:F6) which finds the correct date in D6. In G2 If I have
=OFFSET(D6,2,0) I get the value from D8- it works. Why doesn't
=LOOKUP(INDIRECT(F1),2,0) work. I get a REF error. I need to find the last
week ending date from that range and get the values from that column. Any
help would be much appreciated.

Thanks, Mike