Formula to correlate rows/columns

  • Thread starter Thread starter jmartineau
  • Start date Start date
J

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!
 
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
 
Back
Top