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