Dan

=INDIRECT("Sheet2!B" & COLUMN()+19)

Entered in A1 of Sheet1


Gord

On 15 Mar 2007 15:33:36 -0700, "Dan Oakes" wrote:

Actually, just a sec... What if my data starts on "Sheet2!B20"?

I tried this and it doesnt work:
=INDIRECT("Sheet2!B20" & COLUMN())

Thanks again,
-- Dan