Transpose Maybe?
Hi Dan
Try the non-volatile solution of
=INDEX(Sheet2!$B:$B,COLUMN(A1)+19)
--
Regards
Roger Govier
"Dan Oakes" wrote in message
ups.com...
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
|