Extend formula row reference across columns

[Joe M.]

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]

You could replace it with a different formula:

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