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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking cell ranges between rows and columns 1
using the =page! feature to transpose a row to column 0
Excel Help to copy information from one row at a time to another sheet 1
Moving Column data formula 1
Excel functions 0
Locking a cell reference in a formula 1
Copy non merged to merged cells again 1
Adding Columns with Multipliers 4

Back
Top