Reference Column Starting At Lower Cell

[Mcook13]

I want to reference in a cell another cells info that's in another tab.

I have cell A10 that I have referencing cell W2 and copied down in each cell in column A to reference the next cell down in column W. (A11 = W3, A12 = W4, and so on)

So that the cells in column A will change automatically and not return an error value (#REF) if I delete any row in column W, changed the cells in column A to reference all of coiumn W (=W:W) however cell A10 references cell W10 and I need it to start at W2.

I can't figure out how to write OFFSET or INDIRECT formula to make this work.

Please assist!

 

[levy77]

Can you give an example? Having a hard time trying to work out what you want

 

[Twollaston]

i want to reference in a cell another cells info that's in another tab.

I have cell a10 that i have referencing cell w2 and copied down in each cell in column a to reference the next cell down in column w. (a11 = w3, a12 = w4, and so on)

so that the cells in column a will change automatically and not return an error value (#ref) if i delete any row in column w, changed the cells in column a to reference all of coiumn w (=w:w) however cell a10 references cell w10 and i need it to start at w2.

I can't figure out how to write offset or indirect formula to make this work.

Please assist!

=offset(a10,-8,22)

 

[DanteAmor]

Put the formula in cell A10 and copy it down to

=INDIRECT("W" & ROWS($A$1:A1) +1)