Cell Referencing


G

Guest

I have data in sheet1 in cells A1:A5.

In cell C3 of Sheet2 I want to place this formula "=Sheet1!A1". Based on
that formula lookup, I want Cell D3 to look at Sheet1!A2, Cell E3 to look at
Sheet1!A3, and so on ...

If I changed the formula in cell C3 of Sheet 2 to "=Sheet1!B1" I would want
all the other cell references to automatically change to Sheet1!B2,
Sheet1!B3, etc.

Does anyone know how to do this?
 
Ad

Advertisements

J

JE McGimpsey

One way:

Choose Insert/Name/Define:

Name in Workbook: BaseCol
Formula: =Sheet1!$A:$A

In Sheet2:

C3: =INDEX(BaseCol, Column()-2)


To change to B1,B2, change the definition to Sheet1!$B:$B using
Insert/Name/Define.
 
Ad

Advertisements


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

Top