You could replace it with a different formula:

=index(sheet2!d:d,column())



Joe M. wrote:

I would like to drag to extend the row reference across columns. See below
example. Can this be done?

Col A B C D
E.....
=sheet2!D1 =sheet2!D2 =sheet2!D3 =sheet2!D4

Thanks,
Joe M.

--

Dave Peterson