While investigating ways to return values from multiple worksheets I
noticed something unusual.
In a new workbook enter some data in cells a1:c3 then try:

=LOOKUP(3,{1,2,3},INDIRECT("a1"))
=LOOKUP(3,{1,2,3},INDIRECT("a1:a2"))

On xl2002 (10.2614.2625), these formulas return the values of C1 and
A3 even though no reference is made to these cells. Does this happen
in other versions too?