Formula to correlate rows/columns
 

I have a row of formulas in one sheet that need to refer to a column
of values in another. That is, in the formula sheet, I have a row like
this:

A1: "=Data!A1"
B1: "=Data!A2"
C1: "=Data!A3"
D1: "=Data!A4"

Is there an easy way to get this to work so that I can either copy and
paste or use Fill Right to generate more formulas in the row, and have
them refer to the corresponding column values in the data sheet?
Thanks!

Formula to correlate rows/columns
 

This will work based on your posted sample:

=INDEX(Data!$A:$A,COLUMN())

Copy across as needed.

If your posted sample is just a made-up example:

=INDEX(Data!$A5:$A100,COLUMNS($A:A))

Adjust the range as needed: Data!$A5:$A100

Biff

wrote in message
oups.com...
I have a row of formulas in one sheet that need to refer to a column
of values in another. That is, in the formula sheet, I have a row like
this:

A1: "=Data!A1"
B1: "=Data!A2"
C1: "=Data!A3"
D1: "=Data!A4"

Is there an easy way to get this to work so that I can either copy and
paste or use Fill Right to generate more formulas in the row, and have
them refer to the corresponding column values in the data sheet?
Thanks!