View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default 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