Formula to correlate rows/columns

[jmartineau]

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!

 

[T. Valko]

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